Excel Enable Event

[stefen054]

hi

I have a question about Enable Events. This property is True by default. however if via code when it is changed to false,it should be reset to True. Excel will not reset to true as it do for screen updating.

Is there anyway to have the excel turned it on by default..as code to turn it on with workbook_open event will not work when its value is false

thanks
Stefen

 

[SkipVought]

Stefen,

Once you have turned events off, it is OFF in that session.

YOU must turn events back on.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[stefen054]

Thanks Skip.