Delete Buttons from Web copy and paste

[DaveAtlanta]

I have copied some data from a website into my spreadsheet and along with it came buttons for Next/Previous. They don't do anything now, but I can't figure how to delete them off my worksheet.

 

[Greg Truby]

Right-click on a toolbar and pick Drawing to make the Drawing Toolbar visible. The second control from the left end of the Drawing Toolbar is a white arrow (the Select Objects tool). Click that to turn on the Select Object Mode. You should then be able to select the buttons and delete them. Then just click the arrow again to turn the mode off and the r-click any toolbar and uncheck Drawing.

 

[DaveAtlanta]

The buttons don't respond. I opened the Drawing Toolbar and selected the White Arrow, but when I try to select a button the button clicks but I still can't delete it. I even tried to select the area around and including the buttons but nothing worked.

 

[DaveAtlanta]

I GOT IT!! Yes!!
I had to turn on the Control Toolbar and click on Design Mode, this allowed me to click on a button which selected it and then just push Delete.

Thanks Greg for your help.
Dave

 

[Greg Truby]

Hmmm, that worked for me (I tested copying text and buttons from here). If you somehow got them to paste as command buttons, then you might try using the Controls toolbar and switching to Design Mode using the Design Mode button and see if you can grab them that way.

If that does not work, then tell us if you have other shapes/objects/controls on the worksheet that you need to preserve or can we write some VBA code that will kill all objects on the worksheet.

 

[Greg Truby]

Were I a quicker typist the sequence of posts would certainly make more sense.

 

[ndktwoforty]

wow! thank you so much! I had the same issue, and it was driving me crazy!! this solution worked great!

 

[Peter_SSs]

I had the same issue, and it was driving me crazy!! this solution worked great!

Welcome to the MrExcel board!

Those suggestions were for very old versions. What about if you try this?

Press F5 -> Special... -> Objects -> OK -> Press the Delete key