How to disable Visual Basic Editor in Excel file

G

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
 
A

AA2e72E

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.
 
Top