[Excel] Add a frame into which user can click and add picture
Using Excel 2010, I want to create an excel sheet that would allow users (very low computer knoledge) to simply click on a frame, and insert a picture. Basically, I'd like it to act exactly as powerpoint allows it.
It needs to restrict the dimension and location, as I don't want the picture to overlap text. It would also be nice if it compressed it to a lower size.
EDIT: found this VB code that works 90%. It drops the picture where I want, but does NOT restrict the size it takes.
You sure you don't need it now? I know it's been some days, but I probably have code to do this. Matter of fact I did it just recently for a client. Basically put the frame and size it where you want it to be first, then set up some code to do the work of browsing for and setting up the picture. I'd put a simple rectangle shape on a sheet and gave it the name myPicture. The code below runs when you click on it (by assigning this macro to the shape). Since VBA really doesn't know how it got to that routine, I search the active sheet for all shapes and when I find the correct one, I set up the picture in it.