Maybe it has something to do with Application Events being disabled.
Try adding this to the beginning of your code.

Application.EnableEvents = True

Regards,
Paul


"bodhisatvaofboogie" wrote in
message ...
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!!! :)