Reply to thread

Message: [QUOTE="ypukpete, post: 6367609"] 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) [/QUOTE]