screen refresh
Is there a way to have the spreadsheet screen refresh after the macor is
finished instead of during the macro run? Currently the changes to the spreadsheet are reflected as the macro runs. I would like the user to see just one refresh when the macro is complete. Tom |
screen refresh
Sub Whatever()
application.screenupdating = false 'Your code here application.screenupdating = true end sub -- HTH... Jim Thomlinson "stinson" wrote: Is there a way to have the spreadsheet screen refresh after the macor is finished instead of during the macro run? Currently the changes to the spreadsheet are reflected as the macro runs. I would like the user to see just one refresh when the macro is complete. Tom |
screen refresh
At the start of the macro use the statement
Application.ScreenUpdating=False stinson wrote: Is there a way to have the spreadsheet screen refresh after the macor is finished instead of during the macro run? Currently the changes to the spreadsheet are reflected as the macro runs. I would like the user to see just one refresh when the macro is complete. Tom |
screen refresh
Application.ScreenUpdating = False
at the start, and just before the end Application.ScreenUpdating = True -- kassie never stop learning "stinson" wrote in message ... Is there a way to have the spreadsheet screen refresh after the macor is finished instead of during the macro run? Currently the changes to the spreadsheet are reflected as the macro runs. I would like the user to see just one refresh when the macro is complete. Tom |
screen refresh
Thank you.
"Jim Thomlinson" wrote: Sub Whatever() application.screenupdating = false 'Your code here application.screenupdating = true end sub -- HTH... Jim Thomlinson "stinson" wrote: Is there a way to have the spreadsheet screen refresh after the macor is finished instead of during the macro run? Currently the changes to the spreadsheet are reflected as the macro runs. I would like the user to see just one refresh when the macro is complete. Tom |
screen refresh
thank you
"Alan" wrote: At the start of the macro use the statement Application.ScreenUpdating=False stinson wrote: Is there a way to have the spreadsheet screen refresh after the macor is finished instead of during the macro run? Currently the changes to the spreadsheet are reflected as the macro runs. I would like the user to see just one refresh when the macro is complete. Tom |
screen refresh
thank you
"Kassie" wrote: Application.ScreenUpdating = False at the start, and just before the end Application.ScreenUpdating = True -- kassie never stop learning "stinson" wrote in message ... Is there a way to have the spreadsheet screen refresh after the macor is finished instead of during the macro run? Currently the changes to the spreadsheet are reflected as the macro runs. I would like the user to see just one refresh when the macro is complete. Tom |
screen refresh
Dim Old_ScrUpdate as Boolean
'Begin get status of Property Application.ScreenUpdating into Old_ScrUpdate Old_ScrUpdate=Application.ScreenUpdating Application.ScreenUpdating = False .....Do It... 'Get old status Application.ScreenUpdating = Old_ScrUpdate It's better! |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com