MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Viewing Worksheets on Different Screens

Posted by Gerald Marshall on November 08, 2001 2:40 PM

When I design a worksheet on my own computer I align it perfectly to suit my screen. Everything is central on the screen. When someone else opens the same worksheet on a different computer the view is either bigger or smaller.
Without having to change the zoom control on each individual computer screen is there any way in which my worksheet can be set up to look the same on everyone else's screen as it does on my own.


Posted by Richard S on November 08, 2001 3:28 PM

It's all to do with screen resolution. As far as I know, there is no way fpor Excel to detect screen resolution and adjust accordingly.

Posted by Tom Urtis on November 08, 2001 3:46 PM

Actually if Gerald's question refers to screen area, there is a way to accomplish what he is after by starting the macro with SetWindow State code that looks at the user's screen area, stores that information, changes the settings per the wishes of the programmer, and ending the macro with code that restores the old settings when completed.

This is an area of programming that the person writing the program should fully understand, before implementing or just plugging in the code to do it. Some VBA books contain such code, and doing your homework beforehand will go a long way towards avoiding making your end users angry if you change their settings, even for a short time while your workbook is activated on their computer. One thing I learned is how intensely territorial some computer users can be.

Good luck, and please read up on this first.

Tom Urtis