Hi is there some vba that I can use to resize pictures in two different ways:
1. vba that reduces two pictures, named Pic 1 and Pic 2, by 10% of their existing size but the pictures need to remain at their central point, ie. the pics don't resize up to the left corner and change position.
2. vba that changes the size of the two pictures, named Pic 1 and Pic 2, by the value in cell A1, eg. the value could be 50%, or 120%, but again the pictures need to remain at their central position.
Any help much appreciated.
1. vba that reduces two pictures, named Pic 1 and Pic 2, by 10% of their existing size but the pictures need to remain at their central point, ie. the pics don't resize up to the left corner and change position.
2. vba that changes the size of the two pictures, named Pic 1 and Pic 2, by the value in cell A1, eg. the value could be 50%, or 120%, but again the pictures need to remain at their central position.
Any help much appreciated.