Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down Box
Greetings,
I have an Excel doc with drop down boxes from the control toolbox. I was able to affect the properties of these boxes by right clicking on them and going ino the dialogue box for formatting the controls. Now when I try to do it, it doesn't give me the right click menu. Is there some method in Excel to reactivate the right click menu on these controls? Perhaps some sort of template mode? Thank you. Rod |
#2
|
|||
|
|||
You can try this:
Press Alt+F11 Press Ctrl+G Type this into the pane that appears at the bottom of the Window and press Enter: Application.CommandBars("Cell").Enabled = True tj "Snakeoids" wrote: Greetings, I have an Excel doc with drop down boxes from the control toolbox. I was able to affect the properties of these boxes by right clicking on them and going ino the dialogue box for formatting the controls. Now when I try to do it, it doesn't give me the right click menu. Is there some method in Excel to reactivate the right click menu on these controls? Perhaps some sort of template mode? Thank you. Rod |
#3
|
|||
|
|||
Disregard my previous post--that's not going to work.
What you may check for is whether or not yp are in Design Mode. Bring up the Control Toolbox and click on the Design Mode button, if it's not activated. It's usually first on the toolbar. tj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
Filling drop down box | Excel Worksheet Functions | |||
Filling drop down box | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |