dslreports logo
 
    All Forums Hot Topics Gallery
spc

spacer

Search Topic:
uniqs
962
share rss forum feed

nickstoy

join:2001-02-03
Saint-Lazare, QC
Reviews:
·TekSavvy Cable

2 edits

[Excel] Add a frame into which user can click and add picture

Hi all

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.

Thanks

EDIT: found this VB code that works 90%. It drops the picture where I want, but does NOT restrict the size it takes.


nickstoy

join:2001-02-03
Saint-Lazare, QC

Re: [Excel] Add a frame into which user can click and add pictur

I'm guessing it's not possible...or I haven't made myself clear enough, please let me know.

How about coding the "change Picture" option that is enabled by right-clicking a picture. Is that codable through VB?

nickstoy

join:2001-02-03
Saint-Lazare, QC
reply to nickstoy
please close. don't need it anymore, we went down an entirely other road


2kmaro
Think
Premium,ExMod 1 BC
join:2000-07-11
ColossalCave
kudos:1
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.

--
...then THINK! again.