I know that the command "Stop" will stop the macro, but then your save
command wont action until you press play again and that presumedly is
not what you want

I think if you ask for a save (activeworkbook.save) then it should save
before continuing. (I think, could be wrong though)

Duncan


phil2006 wrote:

When macros are running is there any way in which you can pause them,
save and resume?

Thanks.


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=556419