Posted to microsoft.public.excel.programming

No Name

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Visual Basic Editor	Ron Rueter	Excel Discussion (Misc queries)	3	October 28th 08 02:48 PM
Protecting Code in Visual Basic Editor (Excel 2003)	Johnny S. NH	Excel Worksheet Functions	1	August 30th 08 07:26 AM
Password in Visual basic editor	Tia[_3_]	Excel Worksheet Functions	0	July 11th 08 08:40 AM
Visual basic editor	Answerfactory	Excel Discussion (Misc queries)	3	October 9th 06 09:13 PM
Visual Basic editor terminates Excel 2003	Jim Zeeb	Excel Programming	3	January 30th 04 08:22 PM

All times are GMT +1. The time now is 03:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us