View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Removing HTML "checkbox" from Excel

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