Set Style is defined in the Control class, and ultimately (or actually, somewhere half-way up) Form inherits from that class. These enums are there to control the way the screen is refreshed / redrawn, and are generally used to avoid flicker. doesn't pop up intelli sense for the Set Style method; it's there, although you cannot see it.
Set Style accepts a Control Styles enum, like Control Styles. Unfortunately, I do not have a complete and working solution, but these keywords may get you in the right direction. NET that is made much harder than it used to be, to provide (probably) a much more flexible solution..... Cheers, Imar --------------------------------------- Imar Spaanjaars Everyone is unique, except for me. It removes all the objects at the same time, with only one screen refresh, which is what I wanted. But making the objects visible again still flickers as each object is drawn.
This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.
You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating.
This means that the Word screen can look like it has "gone crazy" while the macro is running.
is your source for cost-effective Microsoft Word training.
Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.
Article contributed by Daryl Lucas Many people know they can speed execution of Word Automation by turning off screen updating: Word. Screen Updating = False Many do not know, however, that they can get an even greater speed boost by hiding the application altogether.
Many people write their own macros to manipulate the information in a workbook.
Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.
Many people write their own macros to manipulate their documents.
Many times the macro may do quite a bit with the document, such as jumping to different places, replacing text, and taking other types of actions.