How to disable Ctrl+Break
 

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

How to disable Ctrl+Break
 

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