Quote:
Originally Posted by Ed Law
Hi Oris,
I tried it and it worked. However when I tried it on Excel 2007, I think it changes it back to its original size and then stretch it to Height = 250 without maintaining the aspect ratio. I tried a few things but none seems to work. Can anybody help? I would like to make this work for everybody as more and more people will be using Excel 2007. Thanks.
Ed
|
Try replacing:
Code:
P.ScaleHeight 1, True
P.ScaleWidth 1, True
P.Height = 250
with:
Code:
P.LockAspectRatio = msoTrue
P.Height = 250
I don't have Excel 2007 on my current computer, so I didn't get a chance to test it.
-Oris-