Resizing autoshapes to fit different monitors

  • I have a sheet set up with three autoshapes that act as buttons. I've disabled all the scrollbars, tabs etc so the buttons are the only thing visible on a blank white sheet.


    The people using this can have varying monitor sizes, so is there a way to resize the 3 shapes if they dont fit on the screen?

  • Re: Resizing autoshapes to fit different monitors


    Hello,


    The initial step is to get the basic monitor infos ...


    see macro below



    Hope this will help ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Re: Resizing autoshapes to fit different monitors


    I do something similar and use this in workbook open


    Code
    On Error Resume Next
    ThisWorkbook.Sheets("Home").Activate
    Range(Cells(1, 1), Cells(37, 26)).Select
    ActiveWindow.Zoom = True
    On Error GoTo 0


    Idea being it will select where the range of buttons you want to see is, and adjust the zoom so its all visible for you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!