Depends on the version of excel:

In xl2002+, you can do something like:

Application.CommandBars.DisableCustomize = True

Before that, you could disable _ALL_ the double clicking with something like:

Option Explicit
Sub testme()
Application.CommandBars("Toolbar list").Enabled = False
Application.CommandBars("Tools").Controls("Customi ze...").Enabled = False
'and if you want to stop the doubleclicking in the commandbar area
'from bringing up the customization dialog:
Application.OnDoubleClick = "donothing"
End Sub

Sub donothing()
' MsgBox "hi"
End Sub

But disabling the doubleclick kills it for everything.

To bring it back,
Application.OnDoubleClick = ""



halem2 wrote:

Hi:

I'm using

Application.CommandBars("Toolbar List").Enabled = False

to prevent the right click on the toolbar but if you double-click on an
empty space in the tool bar, it still shows the Customize box with
Toolbars, Commands and Options.

Is there a wa to restrict the double-click also? thanks!

--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=261702

--

Dave Peterson