S Steve Oct 24, 2007 #1 HYCH Is there a way of disabling the Tools Option on the menu bar with VBA? Steve
D Dave Peterson Oct 24, 2007 #2 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.
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.
S Steve Oct 24, 2007 #3 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. Click to expand... thanks dave, should be fine, users are novices with pc, so this will suffice 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. Click to expand... thanks dave, should be fine, users are novices with pc, so this will suffice Steve
R Ron de Bruin Oct 24, 2007 #4 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
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
