Screen size and Window size

[ypukpete]

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)

 

[Leith Ross]

I have designed several programs on my PC with the worksheets sized t
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.
have a
cmd button on each sheet that opens the zoom dialog to allow the use
to
adjust if required but this is laborious when there can be up to 5
odd
sheets. Is there code that I can use in say,This Workbook (open) tha
will do
this automatically or is there another way?
Thanks for your help. (I am using excel 2000)

Hello ypukpete,

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

--
Leith Ros

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/

 

[ypukpete]

No, I am using them in Excel. But I have resized them using Zoom to fit my
screen to display the info I want the user to see. The zoom size is about 80
to 120% depending on the sheet. Perhaps this is the problem? When I load it
on another PC with a different screen size it is either too big or small for
the screen.
Come back to me on this please.
Thanks

 

[AussieDave]

No, I am using them in Excel. But I have resized them using Zoom to fit my
screen to display the info I want the user to see. The zoom size is about80
to 120% depending on the sheet. Perhaps this is the problem? When I load it
on another PC with a different screen size it is either too big or small for
the screen.
Come back to me on this please.
Thanks

Having experienced the same problem many times, I now include the
following Auto macro when necessary.

Sub Autpen()

Sheets("MySheet").Activate
Columns("A:N").Select 'Specify the columns you want to be
visible
ActiveWindow.Zoom = True

End Sub

This then automatically displays the selected columns across the full
screen. Repeat as necessary for any other sheets that will be
displayed, changing the sheet name and columns to suit.

HTH
Aussie Dave

 

[ypukpete]

Thanks mate, works like a charm in my application. But can you explain what
you mean by an Auto macro. I am fairly new to VBA etc. Thanks for your help.

 

[AussieDave]

Thanks mate, works like a charm in my application. But can you explain what
you mean by an Auto macro. I am fairly new to VBA etc. Thanks for your help.

Basically, anything you code into a macro called "Sub Autpen" will
be actioned automatically as soon as the spreadsheet is opened - you
don't need to invoke it.

Good luck,
Aussie Dave

 

[ypukpete]

Thanks for your help.
Has made a big difference to my application.
Keep an eye open for me...I sometimes ask questions I cant find
in the threads. but I go through them all first before I ask.
Nice to know there are people willing to help.