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:

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