VB code to continue macro

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
 
F

Fred Smith

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

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
 
F

Fred Smith

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