MedievalMan
Board Regular
- Joined
- Dec 14, 2004
- Messages
- 57
Right now the Excel program I'm making is used to insert pictures of various parts into predefined regions for reporting purposes -- the program also inserts a watermark onto the image and saves them with a standard naming convention- but that's a bit beside the point.
Anyway, what I'd like to be able to do:
Make a button which would act just like the "crop" button on the picture toolbar (as these are too easy to hide/change between users). That is, you click the button, and it selects the picture with the crop outline.
I've tried recording a macro, but this does not work, although I can crop progragramatically, i.e.,
Selection.ShapeRange.PictureFormat.CropTop = 42.93
Thanks in advance for the help,
Matt Lawson
Anyway, what I'd like to be able to do:
Make a button which would act just like the "crop" button on the picture toolbar (as these are too easy to hide/change between users). That is, you click the button, and it selects the picture with the crop outline.
I've tried recording a macro, but this does not work, although I can crop progragramatically, i.e.,
Selection.ShapeRange.PictureFormat.CropTop = 42.93
Thanks in advance for the help,
Matt Lawson