+ Reply to Thread
Results 1 to 5 of 5

Screen Sizes (and moving across screens)

  1. #1
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,820

    Screen Sizes (and moving across screens)

    Good afternoon all,

    We have a sheet that needs (ideally) to be displayed in full on screen. Most of the users are now using a Surface Pro linked to dual monitors (both monitors are the same size & resolution) therefore they may open the sheet on any of the 3 screens and potentially move it from one to another.

    I have basic code to identify the screen resolution which I figured I could just run whenever the sheet is activated to resize and move items to get them on screen.

    trouble is, it appears all 3 screens are set to 1680 x 1050 but the Surface Pro is set to change the size of text, apps etc by 225%.

    Is there anyway to return that data in order to take it into account?

    (oh and this is being used by numerous users who may all have their monitors/ Surface set to different settings.)
    Last edited by pjwhitfield; 03-12-2018 at 09:42 AM.
    If someone has helped you then please add to their Reputation

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,084

    Re: Screen Sizes (and moving across screens)

    Hi,

    If you are trying to make a specific range fit on screen, all you need do is select it and then run
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,820

    Re: Screen Sizes (and moving across screens)

    Ok so that is pure genius.

    Next stage, is it possible to run that automatically on the workbook moving screens? ie if a user opens it on the Surface and then drags it to one of the monitors or vice versa?

    Im guessing not and its no great hardship to just include it in the worksheet select so users reclick the sheet to resize but it would be nice...

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,084

    Re: Screen Sizes (and moving across screens)

    It could probably be done with a lot of API code to set up mouse hooks and whatnot, but more trouble than it's worth I would suggest.

  5. #5
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,820

    Re: Screen Sizes (and moving across screens)

    I'm not even going to bother trying then

    Many Thanks for the help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-16-2016, 11:40 AM
  2. [SOLVED] Screen Element Sizes
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2016, 12:00 PM
  3. activeX controls command buttons are moving arround and changing forms and sizes
    By mandura in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2015, 02:18 AM
  4. [SOLVED] moving average with differing bin sizes
    By mchapman47 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-03-2013, 04:13 PM
  5. Replies: 0
    Last Post: 08-07-2012, 07:24 AM
  6. [SOLVED] Adjust screen resolution automatically to fit all screen sizes
    By Ace_XL in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 08:51 AM
  7. [SOLVED] Moving Excel Charts into Word Documents: font sizes change
    By Sam in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1