How to disable the Application Dialogs
 

Hi,

If possible, I'd like to disable the Application Dialog for Customizing
toolbars...

Is that possible?

thanks...

Philip

How to disable the Application Dialogs
 

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