View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.
.