View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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