software

I am using an xlm macro program which pauses to allow for user input.
However, the quot;Continuequot; 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,
Fredquot;Brianquot; gt; wrote in message
news
gt;I am using an xlm macro program which pauses to allow for user input. However,
gt;the quot;Continuequot; button to finish off does not work. Any suggestion for a
gt;replacement using VB to continue with the macro execution? Am using Office
gt;2003. Any help is appreciated.
gt;
gt; Brian
gt;
Invoice.xlm is the macro program.
Here is the relevant bit:
=OPEN(quot;E:\Invoice\ID1042.xlsquot;)
=ALERT(quot;Enter transaction details then click resume.quot;,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

quot;Fred Smithquot; gt; wrote in message
...
gt; My first suggestion is to post the macro, or the part surrounding the user
gt; input.
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;Brianquot; gt; wrote in message
gt; news
gt;gt;I am using an xlm macro program which pauses to allow for user input.
gt;gt;However, the quot;Continuequot; button to finish off does not work. Any suggestion
gt;gt;for a replacement using VB to continue with the macro execution? Am using
gt;gt;Office 2003. Any help is appreciated.
gt;gt;
gt;gt; Brian
gt;gt;
gt;
gt;
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,
Fredquot;Brianquot; gt; wrote in message
...
gt; Invoice.xlm is the macro program.
gt; Here is the relevant bit:
gt; =OPEN(quot;E:\Invoice\ID1042.xlsquot;)
gt; =ALERT(quot;Enter transaction details then click resume.quot;,2)
gt; =PAUSE()
gt;
gt; Sheet ID1042.xls has a button which when clicked, resume executing the rest of
gt; the codes in Invoice.xlm. As Excel 11 in Office 2003 does not support the
gt; macro resume command (or does it?), how do you get around it using VBA?
gt;
gt; Brian
gt;
gt; quot;Fred Smithquot; gt; wrote in message
gt; ...
gt;gt; My first suggestion is to post the macro, or the part surrounding the user
gt;gt; input.
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt; Fred
gt;gt;
gt;gt;
gt;gt; quot;Brianquot; gt; wrote in message
gt;gt; news
gt;gt;gt;I am using an xlm macro program which pauses to allow for user input.
gt;gt;gt;However, the quot;Continuequot; button to finish off does not work. Any suggestion
gt;gt;gt;for a replacement using VB to continue with the macro execution? Am using
gt;gt;gt;Office 2003. Any help is appreciated.
gt;gt;gt;
gt;gt;gt; Brian
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;