View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default find picture objects

I meant if you had them on the worksheet. It won't affect the toolbox
itself.

--
Regards,
Tom Ogilvy

"Dave B" wrote in message
...
Wow, that was embarrassingly easy. Will it delete custom controls in the
Controls Toolbox, or ALL controls in the toolbox? Will they come back

when
I relaunch Excel? Thanks.


"Tom Ogilvy" wrote in message
...
ActiveSheet.Pictures.Delete

but this will delete controls from the Control Toolbox Toolbar as well -

but
that may not be an issue.

--
Regards,
Tom Ogilvy

"Dave B" wrote in message
...
I have an Excel worksheet with some picture objects in it that I don't

want.
How could I use VBA to delete all the pictures in the worksheet?

Thanks
for
all your help.