PDA

View Full Version : look good on any screen resolution



ndendrinos
11-12-2006, 08:02 PM
Hello , Is there a way to have a file open and adjust itsel to the screen resolution of the computer it is used on?
The adjustment I can come up with by trial and error with "zoom"
Code: ActiveWindow.Zoom = 100 would be OK for let us say 800 by 600
ActiveWindow.Zoom = 135 would be OK for let us say 1024 by 768

johnske
11-12-2006, 08:06 PM
Have a look here > http://www.vbaexpress.com/kb/getarticle.php?kb_id=337

ndendrinos
11-12-2006, 08:13 PM
John, what can I say but thank you again.

ndendrinos
11-12-2006, 08:24 PM
Just finished testing it and it works great. There is however the business of Excel as well as the file itself starting up "minimized" .
Any way to overcome this ? You know this posting is a by product of the other one you've helped with were om open the code would get the hard disknumber of the computer it is used on ... and I was hoping that somehow I could get a code to check the resolution on the computer it is used on.
I hope I explain this well
Thanks