Forcing Events to happen
 

Hi

Is there anyway to make sure events happen once the workbook has been opened with macros enabled

I need this to work in XP and 97 verisons of Excel

I always want the open, beforesave and beforeclose events to always occur no matter whether somone has type enableevents = false

Forcing Events to happen
 

Hi Steven,

Is there anyway to make sure events happen once the workbook has been opened with macros enabled?

I need this to work in XP and 97 verisons of Excel.

I always want the open, beforesave and beforeclose events to always occur no matter whether somone has type enableevents = false


You could set an ontime event that fires a macro that sets the EnableEvents property back to True each time.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com