Application screenupdating does not work
The workbook has a number of worksheets (mostly hidden) that are used for processing or as the final visible view - when opened, only one sheet is visible (used to launch the main sub).
While running, one of the subs unhides and activates the final worksheet, then deletes the starting worksheet - and toggles screen updating back on ("True"), and exits back to the main sub (which calls another sub again).
But it doesn't change view, the view stays on the deleted sheet while the subs all finish.
(I can "trick" it into changing view to the newly active worksheet by inserting a "Msg Box" - but don't want to do that.) This has been a hard one for me to search out answers (because looking up "Screenupdating" and anything else brings up a myriad of answers regarding "how to stop the screen from updating"). Display Alerts = True End Sub Private Sub ADSform Gen() Application.
Screen Updating has been set to false Do you get the same results? The following Sub Test With Comments() provides additional information. It's polite to mention when you've done this, so folk don't waste time answering something which has already been answered elsewhere.
Thanks, Sub Test WIth Comments() 'Demonstrates Workbook. Screen Updating = False ' Windows 8.1 V 6.3.9600 Build 9600 ' Excel 2013 (15.0.4551.1510) MSO(15.0.4551.1508)32-bit 'Place this procedure in any workbook ' Create a workbook named Book2in the same path as the workbook with this code ' If "Application. I have run the first code block several times to verify the results are as described. Active Workbook.name" in the Immediate Window which returns "Book2.xlsm".
The biggest problem I'm running into is that when I run the code (despite having Screen Updating set to False), it visibly opens the library file while it runs the macro.
I have changed it slightly so it loops 10,000 times and I execute it 10 times for sample size.Screen Updating = False" is commented out then _ This Workbook is active at the end of the procedure _ Else _ Book2is active at the end of the procedure Application. If I eliminate the commands involving Screen Updating from Test(), the workbook calling Test() is active when it completes, not Book2.The problem only occurs in Excel 2013- It does not occur in previous versions of Excel.This Workbook should be active at the end of the procedure, but it is not.Comment out the first line of code and This Workbook is active at the end of the procedure The actual code I was running when I first encountered the problem would cause a runtime error if This Workbook. I am guessing it is something to do with the SDI Excel 2013 uses. Screen Updating to true before This Workbook.activate and after to no affect. As a work-around I use a Msg Box at the end of the procedure, which for some reason activates Thiswork Book when Application. Name" is commented out then _ Book2is active at the end of the procedure _ Else _ This Workbook is active at the end of the procedure 'Msg Box This Workbook. Screen Updating = True End Sub Crossposted: microsoft.com/Forums/wpapps/en-US/…
Search for application screenupdating does not work:
Paste Special Paste:=xl Paste Values, _ Operation:=xl None, Skip Blanks:=False, Transpose:=False Application.