I need to check in Auto Open event of workbook if the current screen resolution is 1024*768, if not set 1024*768.
In Close event of workbook, set the orginal/initial screen resolution of the pc suser.
I have to echo Duane's question, with some stress - I cannot imagine any justification for doing this. Screen resolution, and zoom levels, are USER settings; just because you can change them does not mean you should.
I also note that messing with screen resolutions is very difficult - there are so many possibilities to consider: what do you do if the screen isn't capable of 1024*768? What do you do if the screen is in portrait orientation? What do you do in a multi-monitor set up? What do you do if the user changes the screen resolution while your workbook is open? And so on, and so on, ...
Enjoy,
Tony
------------------------------------------------------------------------------------ We want to help you; help us to do it by reading this:Before you ask a question.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.