Macros running twice - why

[jayers]

Hi - I have been working on some Macros. I am compiling a macro that runs other macros. I have two noticeable problems.

1 - My SaveAs macro runs fine by itself. But when called or ran by another macro, (which calls more than one macro) the SaveAs macro it stops.

2- Many of my macros, when ran by another macro (which runs more than one macro) cycles through twice.

My specific question is about no. 2 and the following are the individual macros and the macro that runs them.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is the macro that runs them -

Please Login or Register  to view this content.

Thanks for any help - Jim A

[Andy Pope]

Have you tried adding a break point in the SaveAs routine and then checking the call stack to see where and why the routine is being run?

[jayers]

Have you tried adding a break point in the SaveAs routine and then checking the call stack to see where and why the routine is being run?

I through in

Please Login or Register  to view this content.

On the SaveAS macro, it didn't report anything - it just stopped.

Thanks for any help - Jim A