xltrader100
New Member
- Joined
- Dec 8, 2009
- Messages
- 17
I've inserted some Pictures onto a worksheet and need to periodically resize them. After resizing, I'd like to later restore the Pictures to their original size. There's a button (Format Picture/Size/Original Size/Reset) that does this, but when I use the Recorder to try to duplicate this function, the code produced uses the saved height and width numbers from when the Picture was originally inserted.
I don't want to have to keep track of these numbers (especially since Excel already does this by itself automatically) and would like to have the functionality of that Reset button in code. Can I do this?
I don't want to have to keep track of these numbers (especially since Excel already does this by itself automatically) and would like to have the functionality of that Reset button in code. Can I do this?