• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Resizing shapes

Portucale

Portucale

Member
Hi,

I have created a workbook containing shapes, the main shape has the size to fit into a 19” monitor and 100% Zoom, now the issue is that when the users open the same workbook on a 22” monitor the size of the shape seems smaller as the screen is wider… is there any way that we can make the shape “grow”or “shrink” according to either screen resolution or screen size?

Any help and all help is very much appreciated,

Cheers
 
Good day Postucale

This question or very similar has been asked before and the answers given can vary a lot, shapes are not by their own properties fixed in a work sheet they float on the sheet at the size set by you, when you open your work sheet on a bigger monitor the shape is still the same size but will appear small due to screen size.

I think you will end up hoping the VBA gurus can help


.
 
You must log in or register to reply here.
Back
Top