Disable ALT+F11
 

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

Disable ALT+F11
 

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

Disable ALT+F11
 

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

--
__________________________________
HTH

Bob

"LiAD" wrote in message
...
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

Disable ALT+F11
 

They can still get to the VBE if they really try, I suspect.
"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"LiAD" wrote in message
...
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

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

Disable ALT+F11
 

If you are trying to restrict access to VBE, password protect your VBE project.
--
If this post helps click Yes
---------------
Jacob Skaria


"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

Disable ALT+F11
 

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

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
They can still get to the VBE if they really try, I suspect.
"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"LiAD" wrote in message
...
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

Disable ALT+F11
 

Thanks for the extra tip

Works well

"JLGWhiz" wrote:

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

Disable ALT+F11
 

Perfect

Thanks again

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"LiAD" wrote in message
...
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