Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Enable Event

Status
Not open for further replies.

stefen054

Programmer
Dec 25, 2007
25
IN
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
 




Stefen,

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

YOU must turn events back on.

Skip,
[sub]
[glasses]Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top