Hi Jeff

A slightly different approach: This fills the/an Excel window with columns A:K no matter
which screen resolution used, no matter if the window is maximized or not:

Sub Test()
Columns("A:K").Select
ActiveWindow.Zoom = True
Range("A1").Select
End Sub

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Jeff Smith" wrote in message ...
Hi,
Two colleagues and I work on one "master" spreadsheet with all of our
company products listing. Only one person at a tiime uses it.
I prefer high screen resolution 1024 x 768 whereas my colleagues prefer the
800 x 600?.

My spreadsheet is designed to fit the whole screen and rather than leaving
different zoom settings, I wonder if it is possible for a macro for a VBA
routine to detect the screen resolution and automatically select the
appropriate zoom (can define). Any assistance here would be greatly
appreciated.

Thanks in anticipation of any kind help.

Jeff Smith