Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pull Down Menu Bar
My pull down menu bar has disappeared from my excel worksheets. Not sure
what I did to make this happen and cannot find anything in help except for toolbars. Can some one please tell me how to get the pull downs turned back on |
#2
|
|||
|
|||
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to get to the immediate window type this and hit enter: application.CommandBars("worksheet menu bar").Enabled = true JB in Kansas wrote: My pull down menu bar has disappeared from my excel worksheets. Not sure what I did to make this happen and cannot find anything in help except for toolbars. Can some one please tell me how to get the pull downs turned back on -- Dave Peterson |
#3
|
|||
|
|||
Dave,
Thanks a lot it worked. In fact I have put it in my "Personal" VBA's so I will never have to ask again. Once again thanks. "Dave Peterson" wrote: Hit alt-f11 to get to the VBE (where macros live) hit ctrl-g to get to the immediate window type this and hit enter: application.CommandBars("worksheet menu bar").Enabled = true JB in Kansas wrote: My pull down menu bar has disappeared from my excel worksheets. Not sure what I did to make this happen and cannot find anything in help except for toolbars. Can some one please tell me how to get the pull downs turned back on -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
right click menu excel | New Users to Excel | |||
What is a Conditional pull down menu? | Excel Worksheet Functions | |||
What is a Conditional pull down menu? | Excel Discussion (Misc queries) | |||
External Data to be used as in a pull down menu in Excel2003 | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |