Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 06:32 PM.


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