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