HWL
Active Member
- Joined
- Dec 1, 2009
- Messages
- 462
I noticed that when I have macros that open files, even after the macro is done running there is often a delay response with Excel when I want to click on cells and such. I believe this has to do with Excel "pinging" the Notify list looking for when the files I open (and since closed) will be available in write mode. I assume this because a popup has come up sometimes several minute later, informing me. I don't care. I have even tried to Workbooks.open(file, readonly) But the delay persists.
I already have functions to speed up the macro:
Application.StatusBar = "****Please Wait***** Macro processing"
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
Application.DisplayAlerts = False
and enabled after run.
Any ideas how I can tell it not to write to Notify List or clear the notify list?
I already have functions to speed up the macro:
Application.StatusBar = "****Please Wait***** Macro processing"
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
Application.DisplayAlerts = False
and enabled after run.
Any ideas how I can tell it not to write to Notify List or clear the notify list?
