10-21-2008, 06:29 AM
I've been working on a document in Microsoft Excel 2000 and got the idea to insert a picture when a image/command button is pressed. I wrote a macro to open MyPic's, retrieve a picture I wanted, resize the pic and put it where I wanted it. Nifty, however I can't seem to get the macro or command button to simply open to MyPic folder and wait for the user to select a picture before running the rest of the Macro - it has to be a specific picture - and can't seem to locate any specific information on the net to do this for Excel (I guess it's pretty simple in Access...). Anyone here know how one might go about doing this? I've tried several tips, including a macro to call Open Pictures (this gave me runtime errors), hyperlinking to the location, however even when it does so, Excel can't figure out I'm trying to insert a picture, lol, amongst other things. I might try MS Forums for this pet project if no one here knows how to do it. Thanks for any replies ahead of time.
"The true value of a human being is determined primarily by the measure and the sense in which he has attained liberation from the self." -Albert Einsetin