Hi,
I am trying to develop code that will help users create reports formatted however they one. One aspect of this that I want to implement is for the user to determine where they want certain pictures to appear on a worksheet and what size they want those pictures. What I am thinking is that the user could insert a placeholder picture anywhere on the worksheet, and then when my macro runs it would replace that picture with an existing picture.
So, what I am looking for is a button that I can click on a worksheet that replaces a placeholder picture with an existing picture. I'm not too concerned how that existing picture is selected, but perhaps a dialog could pop up to select a picture.
The most important part of this is that the new picture would have to be resized to the exact dimensions as the placeholder (even if it skews the aspect ratio), and placed in the exact location of the placeholder.
One thought: the placeholder doesn't necessarily have to be a picture -- if it is easier to have it as shape or something else, it doesn't matter, just something so the user can define where and what size pictures will appear in their reports.
Thanks!
Bookmarks