This was a great solution and worked in seconds ... once I found it :-)

MT



Don Guillett wrote:

Try one of theseSub DeleteSheetDrawingObjects() ActiveSheet.DrawingObjects.
13-Nov-08

Try one of these

Sub DeleteSheetDrawingObjects()
ActiveSheet.DrawingObjects.Delete
ActiveWorkbook.Save
End Sub

Sub shapescut1() 'Tom Ogilvy
ActiveSheet.Shapes.SelectAll
Selection.Delete
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"daydd" wrote in message
...

Previous Posts In This Thread:

On Thursday, November 13, 2008 3:39 PM
dayd wrote:

Removing HTML "checkbox" from Excel
I received a spreadsheet that had data copied from a website. It has
"checkboxes" that I cannot get rid of. I have tried right clicking and then
deleting, deleting columns, coping the sheeting into an new workbook, and
they will not go away. Is there a way to make them go away? Thank you.

On Thursday, November 13, 2008 3:46 PM
Don Guillett wrote:

Try one of theseSub DeleteSheetDrawingObjects() ActiveSheet.DrawingObjects.
Try one of these

Sub DeleteSheetDrawingObjects()
ActiveSheet.DrawingObjects.Delete
ActiveWorkbook.Save
End Sub

Sub shapescut1() 'Tom Ogilvy
ActiveSheet.Shapes.SelectAll
Selection.Delete
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"daydd" wrote in message
...

On Thursday, November 13, 2008 4:36 PM
dayd wrote:

Thank you for the suggestion. I just have one more question for you.
Thank you for the suggestion. I just have one more question for you. Where in
Excel do I insert this information? I am not able to right click on the box.
Unfortunately, we have Office 2007 and it is not as user friendly as XP was.


"Don Guillett" wrote:

On Thursday, November 13, 2008 4:58 PM
Bob I wrote:

Removing HTML "checkbox" from Excel
They are macros, Alt+F11 will open the VB editor

daydd wrote:

On Thursday, November 13, 2008 5:12 PM
dayd wrote:

Removing HTML "checkbox" from Excel
Thank you. :-)

"Bob I" wrote:

On Thursday, November 13, 2008 5:32 PM
Bob I wrote:

Removing HTML "checkbox" from Excel
You're welcome, but Don did the hard part!

daydd wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider
http://www.eggheadcafe.com/tutorials...e-for-web.aspx