Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2013, 08:28 AM
Intruder Intruder is offline block selection in dropdown list Windows XP block selection in dropdown list Office 2007
Advanced Beginner
block selection in dropdown list
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default block selection in dropdown list


have an Excel 2007 file with multiple dropdown lists based on named ranges
some of these lists are free available for any choice by all users
other lists are predefined on 1 value and should NOT be available for changing
How can I block this selection in such a way that users can see the whole list but cannot change the selection (e.g. all values, except the selected item, in enabled values ) ?
thanx
regards
Reply With Quote
  #2  
Old 01-10-2013, 03:28 AM
OTPM OTPM is offline block selection in dropdown list Windows 7 32bit block selection in dropdown list Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
I dont fully understand your query, however, have you considered protecting the cells you dont want changed?
Hope this helps.
Good luck.
Tony
Reply With Quote
  #3  
Old 01-10-2013, 10:20 AM
Intruder Intruder is offline block selection in dropdown list Windows XP block selection in dropdown list Office 2007
Advanced Beginner
block selection in dropdown list
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default

correct
1/ unlock all cells in sheet except cell with predefined list
2/ protect sheet
it works ok in this way, except that items of list are enabled (shown in normal black font color rather than disabled in grey)
but this is minor reason for not using this technique
many thanx
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
block selection in dropdown list dropdown list for documents r_p_t_0 Word 2 12-18-2012 05:55 AM
block selection in dropdown list Dropdown selection value coconutt Word VBA 5 09-13-2012 05:23 PM
block selection in dropdown list Autofill a form which is contingent on a dropdown selection. biffle0764 Word 2 05-09-2012 12:54 PM
Macro to populate a text form field based on dropdown selection koloa Word 0 10-20-2011 11:52 AM
Automatic find replace after selection in dropdown vsempoux Word 0 10-28-2009 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft