Easy Picture Changer

[Lowell1978]

I have a report that people can print out and hand write and hand draw a picture.
I am looking for easy way for people who type them to add picture.
I will put a blank picture so will not affect the guys who print to hand write.
I want the picture process simple for people who struggle with computers.
I will protect sheet and would like them to not be able to move, edit, etc the picture.

What I want is while they cant delete the picture, they can change it but I want to click on the current image with 1 click.

Another words, I Single left click (Double Click at Worst) image and browser pops up for me to select an new image.

[Logit]

.
This macro comes close and hopefully you can use it.

Please Login or Register  to view this content.

Instead of clicking the image, you will need to place a command button next to the image for the user to click.

The routine will clear ALL images on the sheet prior to inserting the new image into the frame. If you have more than one image on the sheet - all images will be affected by the deletion.

[Lowell1978]

How can I make the button transparent, if I can get it transparent, it would work perfect for me.

[Logit]

.
I'm not certain you can make the button invisible or transparent on the worksheet.

However, you can insert a shape, in place of the button, and attach the shape to the macro. The shape can be made invisible, completely transparent or degrees of transparency, etc.
You can add text to a shape to make it look like a button.

INSERT TAB / SHAPES

Select the desired shape, left click on sheet where you want the shape.

You can right click the shape the choose to edit / move / etc.