Home |
Search |
Today's Posts |
#1
|
|||
|
|||
stop macro from flashing sheets
Good afternoon!
I have a macro that refers to multiple sheets. As it goes along in the process, the sheets flash on the screen. This has caused some of the users discomfort. Is there a way to show only 1 sheet (user interface) or a blank screen or a progress bar or hourglass or something so the flashing will not occur. Thank you for any help. |
#2
|
|||
|
|||
as usual, POST your code snippet for comments and suggestions. Probably you
need to quit selecting and/or suppress screen updating. -- Don Guillett SalesAid Software "frendabrenda1" wrote in message ... Good afternoon! I have a macro that refers to multiple sheets. As it goes along in the process, the sheets flash on the screen. This has caused some of the users discomfort. Is there a way to show only 1 sheet (user interface) or a blank screen or a progress bar or hourglass or something so the flashing will not occur. Thank you for any help. |
#3
|
|||
|
|||
Use
Application.ScreenUpdating = False to prevent Excel from updating the display while your code is running. This will also cause your code to run faster. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "frendabrenda1" wrote in message ... Good afternoon! I have a macro that refers to multiple sheets. As it goes along in the process, the sheets flash on the screen. This has caused some of the users discomfort. Is there a way to show only 1 sheet (user interface) or a blank screen or a progress bar or hourglass or something so the flashing will not occur. Thank you for any help. |
#4
|
|||
|
|||
Frenda,
In addition to the other comments about this, you don't have to select sheets or cells to copy, move, or otherwise work on cells. Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").Range ("D5") This would work regardless of the currently selected sheet. It's still faster do turn off screen updating, as Chip said. -- Earl Kiosterud www.smokeylake.com "frendabrenda1" wrote in message ... Good afternoon! I have a macro that refers to multiple sheets. As it goes along in the process, the sheets flash on the screen. This has caused some of the users discomfort. Is there a way to show only 1 sheet (user interface) or a blank screen or a progress bar or hourglass or something so the flashing will not occur. Thank you for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cancel a Link and a Macro | Excel Discussion (Misc queries) | |||
macro to hide sheets | Excel Discussion (Misc queries) | |||
Macro Error when moved Xcel Sheets from User's Home Dir to Networ | New Users to Excel | |||
Subscript & Superscript | Excel Discussion (Misc queries) | |||
Sheets Skip Macro | Excel Discussion (Misc queries) |