I am using an xlm macro program which pauses to allow for user input.
However, the "Continue" button to finish off does not work. Any suggestion
for a replacement using VB to continue with the macro execution? Am using
Office 2003. Any help is appreciated.

Brian

My first suggestion is to post the macro, or the part surrounding the user
input.

--
Regards,
Fred


"Brian" wrote in message
...
I am using an xlm macro program which pauses to allow for user input. However,
the "Continue" button to finish off does not work. Any suggestion for a
replacement using VB to continue with the macro execution? Am using Office
2003. Any help is appreciated.

Brian

Invoice.xlm is the macro program.
Here is the relevant bit:
=OPEN("E:\Invoice\ID1042.xls")
=ALERT("Enter transaction details then click resume.",2)
=PAUSE()

Sheet ID1042.xls has a button which when clicked, resume executing the rest
of the codes in Invoice.xlm. As Excel 11 in Office 2003 does not support the
macro resume command (or does it?), how do you get around it using VBA?

Brian

"Fred Smith" wrote in message
...
My first suggestion is to post the macro, or the part surrounding the user
input.

--
Regards,
Fred


"Brian" wrote in message
...
I am using an xlm macro program which pauses to allow for user input.
However, the "Continue" button to finish off does not work. Any suggestion
for a replacement using VB to continue with the macro execution? Am using
Office 2003. Any help is appreciated.

Brian

Sorry, your problem is beyond my macro knowledge. I suggest you post your
question to the .programming newsgroup. They are much more knowledgeable about
macros.

--
Regards,
Fred


"Brian" wrote in message
...
Invoice.xlm is the macro program.
Here is the relevant bit:
=OPEN("E:\Invoice\ID1042.xls")
=ALERT("Enter transaction details then click resume.",2)
=PAUSE()

Sheet ID1042.xls has a button which when clicked, resume executing the rest of
the codes in Invoice.xlm. As Excel 11 in Office 2003 does not support the
macro resume command (or does it?), how do you get around it using VBA?

Brian

"Fred Smith" wrote in message
...
My first suggestion is to post the macro, or the part surrounding the user
input.

--
Regards,
Fred


"Brian" wrote in message
...
I am using an xlm macro program which pauses to allow for user input.
However, the "Continue" button to finish off does not work. Any suggestion
for a replacement using VB to continue with the macro execution? Am using
Office 2003. Any help is appreciated.

Brian