Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Screen size (2003/10.2614.2625)

    Many of my projects include a THIS WORKBOOK OPEN macro which automatically imposes a full screen, closes the toolbars, switches off the gridlines, etc., and a quit macro which reverses the process. Is there any way of also putting the screen to the correct size?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Screen size (2003/10.2614.2625)

    Do you mean that you want to switch the screen to (for example) 1024 x 768 resolution? That is possible, but I would strongly recommend against it. Windows users usually have several applications open; if one of them changes screen resolution it will probably have undesired effects on other open applications. Moreover, if an error occurs, the user could be left with a changed screen resolution without a way to change it back (many IT departments disable the Settings tab of the Display Properties control panel).
    If you mean something else, please explain.

  3. #3
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screen size (2003/10.2614.2625)

    That is what I had in mind, ideally going back to whatever resolution was in force before opening the spreadsheet when quitting it. Can it be done?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Screen size (2003/10.2614.2625)

    Again, DON'T do it. Switching screen resolutions is acceptable in games, where you normally don't switch to other applications while playing, but not in Excel,, where users will often be working in several applications (Word, Excel, Outlook, browser, ...)

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screen size (2003/10.2614.2625)

    How about adjusting the Zoom level?

  6. #6
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screen size (2003/10.2614.2625)

    Genius. Pure genius. So obvious. Many 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
  •