Thanks Everybody that has responded. I hate to amit it but I was using the
name of the file as opposed to the different names of the worksheets. Also
Don was correct in that I had two macros named the same. This happened
because I had opened another workbook that also had the same macro name and
it was seeing two. O well more to learn.

Thanks again
Frank

"Don Guillett" wrote:

That means that there are TWO of them.

--
Don Guillett
SalesAid Software

"Beep Beep" wrote in message
...
Alan I forgot to add the message I got:

"Ambiguous Name Detected: AptOneInvoice

"Alan" wrote:

Hi Frank,

I would suggest creating a new macro to call your macros vs. calling one
from another. None of the macros would work stand alone without error
except
Macro7 which doesn't call another macro. I would call them using
something
like this:

Sub RunMacros()
Call Macro1
Call Macro2
Call Macro3
Call Macro4
Call Macro5
Call Macro6
Call Macro7
End Sub


Alan


"The only dumb question is a question left unasked."


"Beep Beep" wrote in message
...
I have a number (7) of macros and would like to go to each one when the
previous one is finished running. I forgot the vba command to put at
the
end
of the macro to direct it to the next macro.

Thanks
Frank