Here's how to do the second option:

Range("A1:M30").Select
ActiveWindow.Zoom = True
Range("A1").Select

The first option can be done (you just need to save what toolbars wer
up on another sheet and put them back before the workbook closes).
I've tried this before, and depending on how the user uses excel the
may not like it...



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26545