Thread: Disable ALT+F11
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Disable ALT+F11

In xl2003 you can secure your code by opening the VBE, click Tools
VBAProjectPropertiesProtection and entering a password to lock the project.
Even if the user opens the VBE, they cannot access or change the code for the
project.

"LiAD" wrote:

Hi,

Is it possible to put a code in or change any options to disable the user
from using the ALT + F11 short sut to access VB?

I have disabled all the other menu's etc but I just realised this one could
cause some damage if it gets found. I am trying to get an excel sheet that
can only be used for inputting data.

Thanks
LiAD