ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Controlling toolbar available (https://www.excelbanter.com/excel-programming/331942-controlling-toolbar-available.html)

polandjc

Controlling toolbar available
 
Is it possible to prevent a tool bar from being activated at all?

keepITcool

Controlling toolbar available
 

set cbr.enabled = false will make it
invisible and inoperable.

be carefull when you do it for builtin toolbars
be sure to have a bulletproof method to reset them
also AFTER stateloss.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


polandjc wrote :

Is it possible to prevent a tool bar from being activated at all?


K Dales[_2_]

Controlling toolbar available
 
CommandBars("ToolbarName").Enabled = False


"polandjc" wrote:

Is it possible to prevent a tool bar from being activated at all?


K Dales[_2_]

Controlling toolbar available
 
My previous response doesn't seem to be here!
Use CommandBars("ToolbarName").Enabled = False

"polandjc" wrote:

Is it possible to prevent a tool bar from being activated at all?


polandjc

Controlling toolbar available
 
Crap... already screwed this up... so how do you retreive a toolbar that's
been deleted?! :(

"keepITcool" wrote:


set cbr.enabled = false will make it
invisible and inoperable.

be carefull when you do it for builtin toolbars
be sure to have a bulletproof method to reset them
also AFTER stateloss.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


polandjc wrote :

Is it possible to prevent a tool bar from being activated at all?




All times are GMT +1. The time now is 10:34 AM.

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