When in Macro record mode, I click an image that is pasted into a spreadsheet and the macro does not record the activity. I am wanting to learn how to remove the graphic from the sheet. The graphic is a screen capture screenshot using Gadwin Printscreen. I wish to remove it via macro. How is this done?
Hello
If the image is always called the same thing each time then this line of code should work (Changnig "Picture 1" to what ever the image is called)
If you want to remove all images then I found this script on MR Excel after a quick google. http://www.mrexcel.com/archive/VBA/529.html
Please Login or Register to view this content.
Hope this helpsPlease Login or Register to view this content.
Jim
Last edited by JimmyA; 09-21-2010 at 05:47 PM. Reason: add link to site containg code
The tester() sub worked perfectly. Thank you!
Hi
To delete all the picture objects in a worksheet, execute the statement:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks