One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.
The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.
You can use this method after using the Screen Updating property to disable screen updates. This example turns off screen updating, opens Test.doc, inserts text, refreshes the screen, and then closes the document (with changes saved).
Screen Refresh turns on screen updating for just one instruction and then immediately turns it off.
is your source for cost-effective Microsoft Excel training.
This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.
Although it would be difficult to do an exhaustive test, in theory this should work from any Automation client-Visual Basic, Excel, Power Point, or any other.
The functionality depends on Word, not on the Automation client.
Updates the display on the monitor with the current information in the video memory buffer. Subsequent instructions don't update the screen until screen updating is turned on again with the Screen Updating property. But it also works even if you run your Automation code from Word itself.Word does not need to display itself in order to run.I started to debug, and immediately after the "Screen Updating = false" line executes, I go to the immediate window and type: Debug. Any clues on how to solve it would be greatly appreciated. Screen Updating = True End Sub _________________________________________________________ Private Sub Check_for_Open_Workbook() Application. Screen Updating = false" because I saw the yellow highlight go over the line in debug mode. Calculation = xl Calculation Automatic Application. Screen Updating from within the code instead of the immediate window, but I'm fairly sure what I'll find. This function gets called by an event handler that catches a Commands Bar button event (? Basically, we create a menu bar and one of the buttons in our custom "File" menu is labeled "Load Portfolio" which calls this function. I have encountered the same symptoms and can't think as to why it's happening. I think that maybe something has broken in my excel because even when I closed out of excel and opened a brand new 2003 workbook with no previous code I was getting the same problem. The interesting thing is that *some* of my modules allow Screen Updating to be set to False, there's only a few that don't.Application.screenupdating = false I am currently using in Visual Studio 2008 but i was wondering if anyone knows the equivilent for this version.