Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Alt+F11
Hello all,
i have a program that runs in MS Excel. i do not want any one to see the MS Visual Basic Editor option. i have already disabled Toools-Macros, but AltF11 is a shortcut that i would like to disable. any help would be great. Thanks, Josh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Alt+F11
Why don't you just secure the code with a password.
In VBE ToolOptionsPropertiesProtection then Lock code for viewing. "Josh C" wrote: Hello all, i have a program that runs in MS Excel. i do not want any one to see the MS Visual Basic Editor option. i have already disabled Toools-Macros, but AltF11 is a shortcut that i would like to disable. any help would be great. Thanks, Josh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Alt+F11
Sub noshow()
Application.OnKey "%{F11}", "" End Sub -- Gary''s Student - gsnu200723 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Alt+F11
Personally, I dislike the idea of a specific WB changing the user's
environment to suit its own needs. As you have disabled Tools-Macros, the user can now not see ANY macros, not only yours. Why should this be a good idea, as the user may be working with several Excel files at the same time, not only yours. As advised in the other post, use VBE protection and possibly "Option Private Module" Alternatively look into add-ins and COM addins. NickHK "Josh C" wrote in message ... Hello all, i have a program that runs in MS Excel. i do not want any one to see the MS Visual Basic Editor option. i have already disabled Toools-Macros, but AltF11 is a shortcut that i would like to disable. any help would be great. Thanks, Josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable # | Excel Discussion (Misc queries) | |||
Disable alt+tab | Excel Programming | |||
disable F1 | Excel Discussion (Misc queries) | |||
disable F1 after F2 | Excel Programming | |||
Disable ALT KEY | Excel Programming |