Adjust to screen resolution 
Author Message
 Adjust to screen resolution

Does anyone know how to resize the Excel cells to match
the screen resolution the user is using. For Example if
the user needs to see 5 columns regardless of whether the
screen resolution was 768 x 1024 or 600 x 800 how could
you resize the columns using VBA.


Fri, 16 Sep 2005 13:49:07 GMT  
 Adjust to screen resolution
We can get the screen resolution by API, but I love a
simple and easy way.
please give it a try.

    Range("A1:E1").Select
    ActiveWindow.Zoom = True



Sat, 17 Sep 2005 16:33:25 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Adjusting for Screen Resolutions

2. Prog. App. to adjust to screen resolution

3. problem adjusting screen resolution

4. Screen resolution auto adjusting?

5. Adjusting VB for different screen resolutions

6. Adjust forms to users' screen resolution

7. VB 3.0 help: adjusting control size to screen resolution

8. Adjusting forms / controls for different screen resolutions.

9. How to adjust control sizes and dimensions to suit different screen resolutions

10. Adjusting controls to different screen-resolutions

11. Adjusting controls to different screen-resolutions

12. API-call for getting/adjusting sreen resolution

 

 
Powered by phpBB® Forum Software