Thanks Nigel!

That works great. Much better than what I originally had.

One follow up question, is there a way to incorporate resizing the
worksheet?

In my original coding, I had "ActiveWindow.Zoom = 80". I tried
dropping that into the code you provided and then realized your code is
not actually "selecting" each worksheet, so I don't think
ActiveWindow.Zoom will work.

Any ideas on that problem?

Thanks again for your help!!!


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=548811