Disable ALT+F11

[LiAD]

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

 

[MDubbelboer]

Application.OnKey "%{F11}", ""

 

[Bob Phillips]

application.OnKey "%{F11}","dummy"

 

[Barb Reinhardt]

They can still get to the VBE if they really try, I suspect.

 

[JLGWhiz]

In xl2003 you can secure your code by opening the VBE, click Tools>
VBAProjectProperties>Protection 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.

 

[Jacob Skaria]

If you are trying to restrict access to VBE, password protect your VBE project.

 

[Bob Phillips]

I am sure they can Barb, you can only divert the determined, not stop them
<g>

 

[LiAD]

Thanks for the extra tip

Works well

In xl2003 you can secure your code by opening the VBE, click Tools>
VBAProjectProperties>Protection 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]

Perfect

Thanks again

application.OnKey "%{F11}","dummy"

--
__________________________________
HTH

Bob