Posted to microsoft.public.excel.programming

John Fuller John Fuller is offline

external usenet poster

Posts: 40

Setting Application.EnableEvents=True after Thisworkbook.Close call

Is there anyway to get excel to re-enable application events after i
close a workbook.

Right now I have in some code:

Application.EnableEvents = False
ThisWorkbook.Close
Application.EnableEvents = True

However, the enableevents never gets set back to true as the sub stops
running when excel closes. Any help is appreciated.

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
Application.EnableEvents	DCPan	Excel Worksheet Functions	3	October 18th 08 05:46 AM
Call Application.Volatile(True) NOT WORKING	FARAZ QURESHI	Excel Discussion (Misc queries)	1	May 8th 08 04:50 AM
Application.EnableEvents = true, but no event fires	Wexler	Excel Programming	0	October 19th 04 06:08 PM
Application.EnableEvents	Terry	Excel Programming	2	April 2nd 04 08:25 PM

All times are GMT +1. The time now is 09:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us