RE: Work*** views

From: Frank Stone (anonymous_at_discussions.microsoft.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 04:56:01 -0700

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

>-----Original Message-----
>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
>
>"Jahunga" wrote:
>
>>
>> Hi,
>>
>> I have a file with numerous spreadsheets. Each sheet
fits the screen
>> perfectly on my monitor but other users have different
size screens and
>> 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 as
>> they open the file??
>>
>> Thanks for any help!
>>
>>
>> --
>> Jahunga
>> --------------------------------------------------------
----------------
>> Jahunga's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=15291
>> View this thread:
http://www.excelforum.com/showthread.php?threadid=269169
>>
>>
>.
>