ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent Tool bar buttons from displayinf (https://www.excelbanter.com/excel-programming/276251-prevent-tool-bar-buttons-displayinf.html)

Soniya

Prevent Tool bar buttons from displayinf
 
Hi all,

How can I prevent displaying all tool bars (tool bar
buttons)

even after using

Application.CommandBars("Toolbar List").Enabled = False

still toolbar buutons are displayed and enabled?

TIA
Soniya

Tom Ogilvy

Prevent Tool bar buttons from displayinf
 
That command has nothing to do with whether they display or not.

There are many commandbars - which one are you trying not to display?

Application.CommandBars("Worksheet Menu Bar").enabled = False

might be what you want.

--
Regards,
Tom Ogilvy

Soniya wrote in message
...
Hi all,

How can I prevent displaying all tool bars (tool bar
buttons)

even after using

Application.CommandBars("Toolbar List").Enabled = False

still toolbar buutons are displayed and enabled?

TIA
Soniya





All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com