How to disable Visual Basic Editor in Excel file
 

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

How to disable Visual Basic Editor in Excel file
 

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.

How to disable Visual Basic Editor in Excel file
 

Thanks a lot. This works.

Rgds
Shu
-----Original Message-----
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.
.