Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding menubar & toolbar
how do I hide the menu bar - File Edit Tools etc , when
the workbook is opened? I would also like to hide all the toolbars? Please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding menubar & toolbar
Try this examples
If you only want to hide the menu bar use Application.CommandBars(1).Enabled = False Sub hide() Dim bar As CommandBar For Each bar In Application.CommandBars bar.Enabled = False Next End Sub Sub show() Dim bar As CommandBar For Each bar In Application.CommandBars bar.Enabled = True Next End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "SIMONÉ" wrote in message ... how do I hide the menu bar - File Edit Tools etc , when the workbook is opened? I would also like to hide all the toolbars? Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toolbar "button" for hiding/unhiding sheets | Excel Worksheet Functions | |||
Hiding Control Toolbar Checkboxes | Excel Discussion (Misc queries) | |||
hyperlink in menubar | Excel Worksheet Functions | |||
Create your own Menubar | Excel Discussion (Misc queries) | |||
Hiding the Standard Toolbar | Excel Discussion (Misc queries) |