Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable ALT+F11
Application.OnKey "%{F11}", ""
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disable Alt+F11 | Excel Programming | |||
Disable Alt+F11 | Excel Discussion (Misc queries) | |||
disable F1 | Excel Discussion (Misc queries) | |||
disable F1 after F2 | Excel Programming | |||
Disable ALT KEY | Excel Programming |