Application screen updating
You should never have to make a call to things like .activate and .select when automating.Those are things that excel records in macros, but that can always be circumvented.Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. 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.
You should be able to make a direct call to some method in the rhxl32 add-in.Hi, I've got a listbox which populates a second listbox from cells on a hidden worksheet which is done through macros. Every time I select a value in the listbox, the screen "flickers" to the hidden worksheet. When I hit the button to run the reports, the various reports pop up as they are being run instead of the focus staying on the console page.
I am using and need to use sheetname.activate within each of the report subroutines.Hi Experts, I have a spreadsheet where I have created a console page to run a variety of reports from.While the reports are running, I would like the focus to stay on the console page.The code's below: It errors out in the Else portion. Print Out Copies:=1, _ Preview:=False, Print To File:=True, Collate:=True, _ Active Printer:="Acrobat Distiller", _ prtofilename:=PSFile Name Else Range(Active Sheet.