Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone know why this wont work?
Application.CommandBars("Worksheet Menu Bar").Enabled = True
Application.CommandBars("Worksheet Menu Bar").Visible = False Comes up with an error message, it is in the Onopen code of the workbook. Any suggestions much appreciated, thks, regards, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone know why this wont work?
Hi Mark
You can't use Visible with the Worksheet Menu Bar Use Application.CommandBars("Worksheet Menu Bar").Enabled = False if you want to hide it More info here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark Stephens" wrote in message ... Application.CommandBars("Worksheet Menu Bar").Enabled = True Application.CommandBars("Worksheet Menu Bar").Visible = False Comes up with an error message, it is in the Onopen code of the workbook. Any suggestions much appreciated, thks, regards, Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone know why this wont work?
Dear Ron,
Thanks for your input, appreciate it, rgds, Mark "Ron de Bruin" wrote in message ... Hi Mark You can't use Visible with the Worksheet Menu Bar Use Application.CommandBars("Worksheet Menu Bar").Enabled = False if you want to hide it More info here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark Stephens" wrote in message ... Application.CommandBars("Worksheet Menu Bar").Enabled = True Application.CommandBars("Worksheet Menu Bar").Visible = False Comes up with an error message, it is in the Onopen code of the workbook. Any suggestions much appreciated, thks, regards, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is there a { in my formula and why wont it work? | Excel Discussion (Misc queries) | |||
Control + C wont work | Excel Discussion (Misc queries) | |||
macro wont work | Excel Programming | |||
Why Wont This Work? VBA Help Needed! | Excel Programming | |||
Sumproduct wont work | Excel Programming |