Is there a way to hide the menu item tools/options from end users?
R Ron de Bruin Jul 24, 2006 #2 Run this in the workbook activate and in the deactivate set it to True Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False See also http://www.rondebruin.nl/menuid.htm
Run this in the workbook activate and in the deactivate set it to True Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False See also http://www.rondebruin.nl/menuid.htm