How to disable Ctrl+Break

G

Guest

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
 
A

arno

Hi Shu,
User can press
Ctrl+Break to go into to the VBA editor environment, which
is not supposed to happen.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to disable Visual Basic Editor in Excel file 2
Disable Ctrl-Break 4
mysteriously enters into break mode 5
Can Not Get Macro to Break with CTRL-BREAK 0
Excel Bug when Debugging (When pressing CTRL+BREAK): keeps stoping 1
Disable auto open 1
How to disable CTRL key 1
Break points will be ignored in Excel 1

Top