VB code to continue macro

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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.
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top