Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drop Down Menu
In Word I'm able to attach a calendar as a drop down menu...then a person who
clicks on that drop down menu will see the calendar and then can click a date which will be seen in the cell. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drop Down Menu
Would you like to something similar in Excel?
See Ron de Bruin's site for instructions on using a Calendar Control on a worksheet. http://www.rondebruin.nl/calendar.htm Also note the section for calling the calendar from a Toolbar button. Gord Dibben MS Excel MVP On Tue, 5 May 2009 14:24:15 -0700, Marlas wrote: In Word I'm able to attach a calendar as a drop down menu...then a person who clicks on that drop down menu will see the calendar and then can click a date which will be seen in the cell. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drop Down Menu
You have protected your sheet, with the option select locked cells unticked.
As a result, yur home key takes you to the first unlocked cell. However, this is what you want for data entry! The solution, if you are not doing data entry, and want to get to the protected cells, is to unprotect the sheet. -- HTH Kassie Replace xxx with hotmail "Marlas" wrote: In Word I'm able to attach a calendar as a drop down menu...then a person who clicks on that drop down menu will see the calendar and then can click a date which will be seen in the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down choice needs to lead to another drop down menu | Excel Discussion (Misc queries) | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Drop Down Menu | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |