How to disable Visual Basic Editor in Excel file

[Guest]

Hello,
Can someone tell me how to disable Visual Basic Editor in
Excel file, I think it would be helpful to avoid users
going into the VB editor enviroment by press Ctrl+Break
accidently.

Thanks very much.

Rgds
Shu

 

[Guest]

Insert this line

application.EnableCancelKey =xlDisabled

at the start of your code or in the workbook_open event handler

OR

Protect your code with a password.

 

[Guest]

Thanks a lot. This works.

Rgds
Shu