How do I remove a flash graphic from a work sheet?
 

I was copying and pasting info from a website and now I have a Flash Player
graphic in my worksheet that I can't get rid of and it's covering up some of
my cells. I right click on it and I only get options to "play" the graphic. I
cannot delete it! When I click on the graphic, all functions in Excel "gray
out". I'm stuck.

How do I remove a flash graphic from a work sheet?
 

Try this tiny macro:

Sub shKiller()
Dim s As Shape
For Each s In ActiveSheet.Shapes
s.Delete
Next
End Sub

--
Gary''s Student - gsnu200860


"miscyn57" wrote:

I was copying and pasting info from a website and now I have a Flash Player
graphic in my worksheet that I can't get rid of and it's covering up some of
my cells. I right click on it and I only get options to "play" the graphic. I
cannot delete it! When I click on the graphic, all functions in Excel "gray
out". I'm stuck.

How do I remove a flash graphic from a work sheet?
 

Show the Control toolbox toolbar (view|Toolbars|control toolbox in xl2003 menus)
and on the developer's tab of the xl2007 ribbon.

Click on the Design mode icon on that toolbar.
Delete the shape
click on the design mode icon to get back to normal.

miscyn57 wrote:

I was copying and pasting info from a website and now I have a Flash Player
graphic in my worksheet that I can't get rid of and it's covering up some of
my cells. I right click on it and I only get options to "play" the graphic. I
cannot delete it! When I click on the graphic, all functions in Excel "gray
out". I'm stuck.

--

Dave Peterson