Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet views
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet views
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set up different views of worksheet? | Setting up and Configuration of Excel | |||
Different Views of Same Worksheet | New Users to Excel | |||
Worksheet/Workbook Views | Excel Discussion (Misc queries) | |||
Macro to lock in 14 views on a worksheet | Excel Programming | |||
Copying custom views from one worksheet to another | Excel Programming |