ypukpete;191204 Wrote:
I have designed several programs on my PC with the worksheets sized to
fit my
screen size. My problem is that when I run them on another Pc with a
different screen size they are either too big or small accordingly. I
have a
cmd button on each sheet that opens the zoom dialog to allow the user
to
adjust if required but this is laborious when there can be up to 50
odd
sheets. Is there code that I can use in say,This Workbook (open) that
will do
this automatically or is there another way?
Thanks for your help. (I am using excel 2000)
--
ypukpete

Hello ypukpete,

Excel will automatically resize itself and the worksheets to fit the
current display. So, why are you having problems with the worksheets?
Are you displaying them and not using Excel to do so?


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52682