I need to stop and allow the user to look over and make any necessary changes
to a workbook before my macro opens all the other workbooks and updates their
values. Is there a Pause or Halt process in VBA with Excel 2003

You are not really looking to halt or pause a running macro, so much as you
want to end a macro and allow the user to do whetever stuff they need to do
before you proceed to the next macro. Not knowing your circumstances it is
hard to say just how you want to trigger the next macro. I usually just use a
button (which I may keep disabled until the user has performed some sort of a
required action which will enable the button).
--
HTH...

Jim Thomlinson


"Tomkat743" wrote:

I need to stop and allow the user to look over and make any necessary changes
to a workbook before my macro opens all the other workbooks and updates their
values. Is there a Pause or Halt process in VBA with Excel 2003

How does the button work? I can't just prompt the user if they need to make
changes they usually know in advance if changes are going to need to be made.
Could the button end the Macro and than step back into the Macro at the same
place or do I just make a toolbar button and assign a macro to it? I already
have the choice of two different macros depending on which type of sheet they
are updating from now it would turn into four and I would have to do this for
each day of the week adding another 14 macros which I already am having
difficulty with because I don't know how to do a relative file location code
to follow the file the macro resides in (see my post "Change a Macro commands
reference to file locations")

"Jim Thomlinson" wrote:

You are not really looking to halt or pause a running macro, so much as you
want to end a macro and allow the user to do whetever stuff they need to do
before you proceed to the next macro. Not knowing your circumstances it is
hard to say just how you want to trigger the next macro. I usually just use a
button (which I may keep disabled until the user has performed some sort of a
required action which will enable the button).
--
HTH...

Jim Thomlinson


"Tomkat743" wrote:

I need to stop and allow the user to look over and make any necessary changes
to a workbook before my macro opens all the other workbooks and updates their
values. Is there a Pause or Halt process in VBA with Excel 2003

Lets take a step back. What is this macro going to do? Will the modifications
made by the user change the flow of the macros?

Perhaps a high level discussion of what this spreadsheet does is in order.
What is the flow. When does the user need to get involved and for what
reason. Maybe if we redisign the process a bit we can make this entire
project a lot easier.
--
HTH...

Jim Thomlinson


"Tomkat743" wrote:

How does the button work? I can't just prompt the user if they need to make
changes they usually know in advance if changes are going to need to be made.
Could the button end the Macro and than step back into the Macro at the same
place or do I just make a toolbar button and assign a macro to it? I already
have the choice of two different macros depending on which type of sheet they
are updating from now it would turn into four and I would have to do this for
each day of the week adding another 14 macros which I already am having
difficulty with because I don't know how to do a relative file location code
to follow the file the macro resides in (see my post "Change a Macro commands
reference to file locations")

"Jim Thomlinson" wrote:

You are not really looking to halt or pause a running macro, so much as you
want to end a macro and allow the user to do whetever stuff they need to do
before you proceed to the next macro. Not knowing your circumstances it is
hard to say just how you want to trigger the next macro. I usually just use a
button (which I may keep disabled until the user has performed some sort of a
required action which will enable the button).
--
HTH...

Jim Thomlinson


"Tomkat743" wrote:

I need to stop and allow the user to look over and make any necessary changes
to a workbook before my macro opens all the other workbooks and updates their
values. Is there a Pause or Halt process in VBA with Excel 2003