Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am writing an application in Excel 2003 and want to be able to programmatically turn the toolbars on and off. Can anyone give any pointers on how to do this? Thanks TJ |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi TJ
There are a few examples on this page http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "TJ" wrote in message ... Hi I am writing an application in Excel 2003 and want to be able to programmatically turn the toolbars on and off. Can anyone give any pointers on how to do this? Thanks TJ |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can make them invisible as below or bay changing .visible to .enabled
simply grey them out, Don't forget to re-enable them. Sub drastic() With Application.CommandBars("Worksheet Menu Bar") .Controls("&Edit").Visible = False .Controls("&Window").Visible = False .Controls("&Insert").Visible = False .Controls("&File").Visible = False .Controls("&View").Visible = False .Controls("&Format").Visible = False End With End Sub Mike "TJ" wrote: Hi I am writing an application in Excel 2003 and want to be able to programmatically turn the toolbars on and off. Can anyone give any pointers on how to do this? Thanks TJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Toolbars | Excel Discussion (Misc queries) | |||
Toolbars | Excel Discussion (Misc queries) | |||
toolbars | Excel Discussion (Misc queries) | |||
Please Help, No Toolbars in my view-toolbars! | Excel Programming | |||
Code to automatically turn on and turn off Track Changes | Excel Programming |