Posted to microsoft.public.excel.misc

Diana[_2_] Diana[_2_] is offline

external usenet poster

Posts: 1

Drop Down Menu

Hi

How can I lock a dropdwown menu only from adding anything other than what I
have on the list. I have the show error alert clicked but it is still
allowing me add to the list. Is there a specific source or data validation I
need to type. I am only want to lock the dropdown menu on my worksheet.

Thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop Down choice needs to lead to another drop down menu	Hudson	Excel Discussion (Misc queries)	1	January 9th 09 12:36 AM
Drop dwn menu. Formula to count selection frm menu in anoth cell?	ggoldber	Excel Worksheet Functions	1	June 4th 08 02:21 PM
filter dropdown menu so 2nd drop menu is customized	menugal	Excel Worksheet Functions	1	September 4th 07 05:25 PM
Drop down menu	enyaw	Excel Discussion (Misc queries)	1	June 16th 06 12:29 PM
Cross-referenced drop-down menu (nested drop-downs?)	creativeops	Excel Worksheet Functions	4	November 22nd 05 05:41 PM

All times are GMT +1. The time now is 07:39 AM.

About Us

"It's about Microsoft Excel"