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.
|