Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a Excel file with some forms. User can press Ctrl+Break to go into to the VBA editor environment, which is not supposed to happen. Can someone tell me how to avoid this or disable this function? Thanks very much. Rgds Shu |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Shu,
User can press Ctrl+Break to go into to the VBA editor environment, which is not supposed to happen. 1) use Application.EnableCancelKey = xlDisabled at the beginning of your code to avoid ctrl+break 2) hide your vba modules and protect them with a password vba-editor, menu extras/properties of vba-project/protection activate the field and enter a password there. This is _no_ absolute protection, however, you cannot do more. regards arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
disable CTRL-pageup & pagedown | Excel Discussion (Misc queries) | |||
Disable CTRL+D??? | Excel Discussion (Misc queries) | |||
Stopping a macro without using Ctrl Break | Excel Programming | |||
How to disable the Ctrl+Break ? | Excel Programming | |||
disable ctrl+s | Excel Programming |