Zoom to selction-Persistant?

I have an inventory system which is viewed on many different monitor sizes around the office. Is it possible to make the document always zoom to a given selection ("A:G") for example. I wouldn't mind using macros if need be but I only want it to run the first time a sheet is selected after opening.
Thanks!

Sorry? The file is edited on one workstation and backed up to the server as a read only file. so far I am using

Please Login or Register  to view this content.

This does the job but runs every time a sheet is selected, which makes it flicker. I need something similar to this but only runs the first time a given sheet is selected then does nothing untill the next time the document is opened.

I tried

Private Sub Worksheet_Initialize()

but it didn't do anything.

Thanks for any advice

Still runs every time the sheet is selected. Odd how tricky it is, I would have thought there would be a reasonably good demand for a simple way to do this

Please Login or Register  to view this content.

Sixth code works fine for me
as for flickering....application screenupdating might solve that

Ah, yes I needed to move it to the top of the page as it was getting stuck on to the bottom of the code above. Works perfectly now thanks very much!
I was thinking to tell it not to run if a2 is already selected but this is much better.