Cheers matey - as simple as that hey!..great stuff!
Might avoid the other option for the time being as it might upset some
users if anything goes wrong and they are left having to sort out
their toolbars from a fresh!

kkknie wrote in message ...
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 were
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 they
may not like it...

K