I use application.statusbar to keep the users apprised of what is happening.I have tried using application.screenupdating = false both before I branch to a report subroutine and also within the report subroutine in an attempt to keep it from shifting the focus to the report page, but it is not working.Alain ute is that if anyone configures addins differently or anything, that messes with the order of controls in the toolbar, simply telling a certain control to execute might run the entirely wrong thing.
Those are things that excel records in macros, but that can always be circumvented.
And then put a debug.print before/after each line (including before after the select line). and then put a debug print after the called sub ends and the code returns to the original sub. Well that narrows it down to the selecting I guess, and I guess further that it's specifically the selection of a sheet that wasn't the active sheet when you launched the macro.
And then put a debug.print before/after each line (including before after the select line).
If you have turned off screen updating using the line Application.
Screen Updating = False at the beginning of your code, then if any user runs the code, they will not know what is going on and think that the computer system is not responding.
Search for screenupdating true:
Enable Events = True End Sub Sub DP_disbursement() Application.