Drop Down Menu

M

Marlas

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.
 
G

Gord Dibben

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
 
K

Kassie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down menu formatting 2
why don't i get colour in my drop down menu 1
Drop down menu with validation that requires Marco 1
Drop down menu 2
Chart Title change with Drop Down Selection 2
Excel Excel: How do I put a formula in a drop down list 11
How to keep formula and be able to input value in cell? 0
Building a Pricing Model 2

Top