How to disable the Application Dialogs>

[Guest]

Hi,

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

Is that possible?

thanks...

Philip

 

[Jim Rech]

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
| Hi,
|
| If possible, I'd like to disable the Application Dialog for Customizing
| toolbars...
|
| Is that possible?
|
| thanks...
|
| Philip