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

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

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
--
ypukpete


"Leith Ross" wrote:


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

On Jan 21, 7:07*pm, ypukpete
wrote:
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
--
ypukpete


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

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.
--
ypukpete


"AussieDave" wrote:

On Jan 21, 7:07 pm, ypukpete
wrote:
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
--
ypukpete


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

On Jan 23, 11:19*am, ypukpete
wrote:
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.
--
ypukpete


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

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.
--
ypukpete


"AussieDave" wrote:

On Jan 23, 11:19 am, ypukpete
wrote:
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.
--
ypukpete


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