Thread: Hiding tools/options
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Hiding tools/options
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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"gfkbob" wrote in message ...
Is there a way to hide the menu item tools/options from end users?


Reply With QuoteReply With Quote