Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the "customize" window
Hi
I would like to disable the access to the "customize" wiñdow. I know to make it by disabling the menu item in "tools" menu and selectimg it with the pop-up menu by clicking with the right key of mouse, like the code wiitten below show: Application. CommandBars("Tools").Controls(16).Enabled = False Application. CommandBars("ToolBar List").Enabled = False But remaims the access with double click of the mouse. Anybody knows how to make it? Thanks Rui Álvares email: |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the "customize" window
Maybe:
Application.CommandBars.DisableCustomize = True would work. I think that this was added in xl2002. Are you going to run this in earlier versions? Jim Rech suggested this for previous versions--it disables all the double clicking: Sub SetDoubleClick() Application.OnDoubleClick = "DoNothing" End Sub Sub DoNothing() End Sub Rui Alvares wrote: Hi I would like to disable the access to the "customize" wiñdow. I know to make it by disabling the menu item in "tools" menu and selectimg it with the pop-up menu by clicking with the right key of mouse, like the code wiitten below show: Application. CommandBars("Tools").Controls(16).Enabled = False Application. CommandBars("ToolBar List").Enabled = False But remaims the access with double click of the mouse. Anybody knows how to make it? Thanks Rui Álvares email: -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable autoformat of "true" and "false" text | Excel Discussion (Misc queries) | |||
how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
Can I "customize" an autoformat report for a Pivot Table in Excel | Excel Discussion (Misc queries) | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
Disable "Save" &/or "Close" | Excel Programming |