Forcing Events to happen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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