View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default How do I delete an embedded picture on a worksheet using VBA?

hi GTJames

See
http://www.rondebruin.nl/controlsobjectsworksheet.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"GTJames" wrote in message ...
My VBA routine copies an embedded chart from a worksheet to another worksheet
as a picture (CopyPicture). This works fine but I want to clear the picture
from the destination worksheet before copying anouther picture to it, so the
pictures don't build up. I can't seem to find a way to activate the picture
via VBA so that it can be deleted.