Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Well, in Excel 2002 and later this is available:
CommandBars.DisableCustomize = True Also this will stop someone from right-clicking on a toolbar to get to the toolbar popup: CommandBars("Toolbar List").Enabled = False This (unlike the first one) doesn't stop someone from double-clicking on the menubar/toolbar background area to get to the Customize dialog. More people don't know about this but if it concerns you I think you can stop it using the OnDoubleClick method. -- Jim Rech Excel MVP "Philip" wrote in message ... | Hi, | | If possible, I'd like to disable the Application Dialog for Customizing | toolbars... | | Is that possible? | | thanks... | | Philip |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Dialogs(xlDialogPrint).Show - prints too soon | Excel Discussion (Misc queries) | |||
Application.Dialogs(xlDialogFormulaFind).....HELP!!!!!! | Excel Programming | |||
Can i disable the warning when i open the my VBA application | Excel Programming | |||
Does anyone know how to programmatically disable Application.xlcut | Excel Programming | |||
application.dialogs(xlDialogSaveAs) AND CHDIR | Excel Programming |