Worksheet views

[Jahunga]

Hi,

I have a file with numerous spreadsheets. Each sheet fits the scree
perfectly on my monitor but other users have different size screens an
so have to scroll across to see certain types of data.

Is there a way that I can force the sheets to fit any users page a
they open the file??

Thanks for any help

 

[Katie]

You can put this code behind the sheets that you need to zoom correctly,
where x and y are the beginning and end of the range that you want to fit
onto the screen respectively.

Private Sub Worksheet_Activate()

Range(x:y).Select
ActiveWindow.Zoom = True
Range("A1").Select

End Sub

HTH
Katie

 

[Frank Stone]

hi,
The real problem may be that everyone has their monitors
set up differently. some may be set to 640 by 480 pixels
(largest view possible) while others may 1600 by 1200
pixels (smallext view possible). unless all of the pc's in
your area are set the same, you will have the problem you
discribed not only in xl but everything else as well.
Zoom is about the only fix there is for this problem.
Katie's macro might help (and i just learned
something...thanks katie) but if all the pc are different
you may have to have a macro for each one. so if the macro
thing gets to complicated jest have the others users go
view>Zoom>pick from list.
Regards
Frank