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
|