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