Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Holding a constant page while the macro runs in the background
Hello all...
I've got a macro the performs multiple file open steps and copies range data back and forth between pages on alternating workbooks... the macro works fine... what I'm looking to do is to hold a constant page while the macro steps operate in the background and when all steps are completed, then to pop a message box indicating that the file has been updated... any help would be appreciated -- Joe Mac |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Holding a constant page while the macro runs in the background
hi
add two lines of code. at the beginning... application.screenupdating = false then at the end... application.screenupdating = false msgbox "updated" end sub regards FSt1 "Joe Mac" wrote: Hello all... I've got a macro the performs multiple file open steps and copies range data back and forth between pages on alternating workbooks... the macro works fine... what I'm looking to do is to hold a constant page while the macro steps operate in the background and when all steps are completed, then to pop a message box indicating that the file has been updated... any help would be appreciated -- Joe Mac |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Holding a constant page while the macro runs in the background
Thank you - Exactly what I wanted in the performance
-- Joe Mac "FSt1" wrote: hi add two lines of code. at the beginning... application.screenupdating = false then at the end... application.screenupdating = false msgbox "updated" end sub regards FSt1 "Joe Mac" wrote: Hello all... I've got a macro the performs multiple file open steps and copies range data back and forth between pages on alternating workbooks... the macro works fine... what I'm looking to do is to hold a constant page while the macro steps operate in the background and when all steps are completed, then to pop a message box indicating that the file has been updated... any help would be appreciated -- Joe Mac |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Holding a constant page while the macro runs in the background
Try...
at the start of your procedure place Application.Screenupdating = False & just above "End Sub" Application.Screenupdating = True msgbox "Completed Update" "Joe Mac" wrote: Hello all... I've got a macro the performs multiple file open steps and copies range data back and forth between pages on alternating workbooks... the macro works fine... what I'm looking to do is to hold a constant page while the macro steps operate in the background and when all steps are completed, then to pop a message box indicating that the file has been updated... any help would be appreciated -- Joe Mac |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Holding a constant page while the macro runs in the background
This should do it for you.
Sub YourMacro() Application.ScreenUpdating = False 'your code MsgBox "The file has been updated." Application.ScreenUpdating = True End Sub -- Cheers, Ryan "Joe Mac" wrote: Hello all... I've got a macro the performs multiple file open steps and copies range data back and forth between pages on alternating workbooks... the macro works fine... what I'm looking to do is to hold a constant page while the macro steps operate in the background and when all steps are completed, then to pop a message box indicating that the file has been updated... any help would be appreciated -- Joe Mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Setup Macro runs slow | Excel Discussion (Misc queries) | |||
Holding the result of a formula constant or frozen | Excel Worksheet Functions | |||
holding the result constant | Excel Worksheet Functions | |||
Macro that runs in the background | Excel Discussion (Misc queries) | |||
Runs possible on the background? | Excel Programming |