Thread: HELP - How do I disable Excels menu items so others can't use
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcello do Guzman Marcello do Guzman is offline
external usenet poster
  
Posts: 22
Default HELP - How do I disable Excels menu items so others can't use
I was able to figure out how to disable shortcut keys, but I need to
disable the following menu items so that users can't use them while my
Excel application is open.

- MACROS list box
- Visual Basic Editor


I also need to be able to reinstate the above menu items so that they
can used after I close the Excel application.

I hope you can help me with this and provide the code and where
exactly I should place it in the VBE.

Thank you in advance. Please reply via email:



SIncerely,


Marcello
Reply With QuoteReply With Quote