-
look good on any screen resolution
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
-
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you 
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
-
John, what can I say but thank you again.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote
