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. You should never have to make a call to things like .activate and .select when automating.
Learn more about Auto Macro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Certain vba macros / codes take a long time to run or execute the actions required. Sometimes, there could be one or more macros which cover multiple processes and this status bar will be useful to know at which process, the macro has reached.
Could this be causing the application.screenupdating zorvek, I need to activate the tabs, because I need to access their command bars in order to refresh the data on the report.
Even if I restore the control tab before turning screen updating back on, wouldn't there still be a flash to the report tab while it's activated?
Once we use at the end of the code, it will revert to the default Excel message which is READY.
Display Alerts = True End Sub You can see the code posted in the module below - Now lets understand what each line of the code does - So first we set DISPLAYSTATUSBAR to true and then we set the message for the status bar.taduh If you leave screen updating off until you after you have restored the control tab you should not see any flashing of undesired content. Echo is an Access command, it doesn't work in Excel.Kevin You don't need to activate the tabs or access their command bars to refresh data.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.You should be able to make a direct call to some method in the rhxl32 add-in.Hi Experts, I have a spreadsheet where I have created a console page to run a variety of reports from.