VBA Code To Change All Shape & Chart Placement Properties

VBA Code To Change All Shape & Chart Placement Properties

I deal with shapes and charts on a daily basis and one of my (many) pet peeves is needing to resize column widths and screwing up the size of my shapes and charts. I'm going to share with you a few VBA macros that will allow you to change the Placement property of all the shapes and charts on your ActiveSheet with the click of the button. The last VBA snippet is the one I use personally almost daily. Enjoy!

Read More