Scaling

[TAM]

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

 

[Tom Ogilvy]

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.