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)

 

[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 Auto_Open()

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 Auto_Open" 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.