Macro Section Skipped
I have some fairly complicated macros set up. They work fine on my computer,
I have had no difficulty and use them with great success. However when put
in place on a co-workers computer they do not. I've already went through
line by line to make sure everything is identical, and when testing the
macros they worked fine at first. NOW, strange things are happening as
follows:
I have buttons set up in a spreadsheet that are linked to the macros. Click
button and voila you have everything set to go on it's own. The macro runs,
but skips the last part where it does a page setup and saves the file to a
destination determined by the macro. I placed a stop in the macro where it
skips and then play the macro to that point then step through the rest. It
works fine when I do that. So I'm confused as to why it would work fine
while stepping through, but not when you play it start to finish that is when
it skips that last section of the macro.
Any ideas??? Thanks in advance!!! :)
|