Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling toolbar available
Is it possible to prevent a tool bar from being activated at all?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling toolbar available
CommandBars("ToolbarName").Enabled = False
"polandjc" wrote: Is it possible to prevent a tool bar from being activated at all? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlling Sequence | Excel Discussion (Misc queries) | |||
Controlling Tab Oders | Excel Programming | |||
Controlling VBA | Excel Programming | |||
Controlling the mouse | Excel Programming |