Scaling
 

The problem I have is trying to control how the 'front-end' of my workbook
will appear when it is opened on a pc with a greater or lower resolution.
The 'front-end' is a menu page with several vba list boxes and clip-art
which I have arranged centrally on the worksheet but if I open it on a pc
with a lower resolution for example not all the controls appear and the user
has to scroll down.

Thanks

TAM

Scaling
 

You can try the zoom command

Range("A1:Z26").Select
activeWindow.zoom = True

will have excel do the best job it can fitting the selected area to the
screen.

--
Regards,
Tom Ogilvy

"TAM" wrote in message
t...
The problem I have is trying to control how the 'front-end' of my workbook
will appear when it is opened on a pc with a greater or lower resolution.
The 'front-end' is a menu page with several vba list boxes and clip-art
which I have arranged centrally on the worksheet but if I open it on a pc
with a lower resolution for example not all the controls appear and the
user
has to scroll down.

Thanks

TAM