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

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

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

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

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

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

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

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!