Tip 4 from the page
Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above.
On Error Resume Next
Application.CommandBars("Toolbar List").Enabled = False
On Error GoTo 0
This prevents users double-clicking on the Toolbar area to open the
(Customize Toolbars) dialog in Excel 2002 and above.
Application.CommandBars.DisableCustomize = True
If you want to remove Type a question for Help on the Worksheet Menu Bar you
can use this in Excel 2002 and above. True = hidden and False = visible
Application.CommandBars.DisableAskAQuestionDropdow n = True
You can use this to avoid the error in Excel 2000
If Val(Application.Version) 9 Then
CallByName CommandBars, "DisableCustomize", VbLet, True
CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True
End If
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Steve davis" wrote in message ...
finaly found thank
Application.CommandBars("Toolbar List").Enabled = False