in the activate event for the workbook, select the UsedRange (or range you
want to display) and then set Zoom = True (for the activeWindow).

See Chip Pearson's site for information on using Events

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Jahunga" wrote in message
...

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...o&userid=15291
View this thread: http://www.excelforum.com/showthread...hreadid=269170