LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.Dialogs(xlDialogPrint).Show - prints too soon Almagg via OfficeKB.com Excel Discussion (Misc queries) 3 April 27th 07 08:17 PM
Application.Dialogs(xlDialogFormulaFind).....HELP!!!!!! jason Excel Programming 2 October 1st 04 12:47 PM
Can i disable the warning when i open the my VBA application kvenku[_33_] Excel Programming 1 August 9th 04 12:20 PM
Does anyone know how to programmatically disable Application.xlcut Fonda Excel Programming 1 June 30th 04 01:58 AM
application.dialogs(xlDialogSaveAs) AND CHDIR Jules[_2_] Excel Programming 1 September 3rd 03 08:27 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"