Prev: How unlock locked cells
Next: how do you include todays date in SUMIF formulas
From: Steve davis on 3 Apr 2010 09:59
finaly found thank
Application.CommandBars("Toolbar List").Enabled = False
From: Ron de Bruin on 4 Apr 2010 08:30
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.DisableAskAQuestionDropdown = 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" <Stevedavis(a)discussions.microsoft.com> wrote in message news:EB3B59E2-3F72-4CF1-877F-404F322BC0A6(a)microsoft.com...
> finaly found thank
> Application.CommandBars("Toolbar List").Enabled = False

First  |  Prev  | 
Pages: 1 2
Prev: How unlock locked cells
Next: how do you include todays date in SUMIF formulas