find picture objects
 

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.

find picture objects
 

Try

Sub DelPics()
Activesheet.Pictures.Delete
End Sub

Hope this helps
Rowan

Dave B wrote:
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.

find picture objects
 

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.

find picture objects
 

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.

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.