VBA Question on Toolbars

[Steve]

HYCH

Is there a way of disabling the Tools Option on the menu bar with VBA?



Steve

 

[Dave Peterson]

You can try something like:

Application.CommandBars("Worksheet menu bar").Controls("Tools").Enabled = False

and later to toggle it back:
Application.CommandBars("Worksheet menu bar").Controls("Tools").Enabled = True

It'll be effective until the user resets the toolbar.

 

[Steve]

You can try something like:

Application.CommandBars("Worksheet menu bar").Controls("Tools").Enabled = False

and later to toggle it back:
Application.CommandBars("Worksheet menu bar").Controls("Tools").Enabled = True

It'll be effective until the user resets the toolbar.

thanks dave,

should be fine, users are novices with pc,

so this will suffice


Steve

 

[Ron de Bruin]

I like to add this to Dave's answer

If you also have users that use Non English versions of Excel use this.

Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30007).Enabled = False