I have a worksheet with 4 rectagles that I created using the drawing tool. I am trying to write a macro that will allow me to use 2 buttons, one to insert a image into the predefined shape and another button to reset the shape back to the original default. In the attached workbook, I have a macro that kind of does what i want however, I do not like that if I cancel the "insert image" it dislays the error link to this post. If it is easier, i would be happy if the image was inserted in a box of merged cells as well.....either way accoplishes the task.
error.png
I am using the following macro:
But... I like how this one works: (thanks Steve...aka Nevets)
Bookmarks