Trapping excel application event

[teachMeExcel]

Hi all!, Is there a way to trap application event such as Application.screenupdating = True?. My problem is that in my workbook, I am executing a DLL that is turning the Application.Screenupdating to "On" and I need to have that functionality "Off" so that the users don't see the screen flickering.

Any help or advise on this matter is greatly appreciated.

[JieJenn]

Put this in the beginning line of your module

Application.Screenupdating = False

Put this in the last line within the same module

 application.screenupdating = True

[Paul]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...nupdating.html

Thread Closed.