Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing HTML "checkbox" from Excel
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: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing HTML "checkbox" from Excel
They are macros, Alt+F11 will open the VB editor
daydd wrote: 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: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing HTML "checkbox" from Excel
Thank you. :-)
"Bob I" wrote: They are macros, Alt+F11 will open the VB editor daydd wrote: 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: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing HTML "checkbox" from Excel
You're welcome, but Don did the hard part!
daydd wrote: Thank you. :-) "Bob I" wrote: They are macros, Alt+F11 will open the VB editor daydd wrote: 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: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to make a checkbox usable for users to "check" it? | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Removing the "broom" that pops-up in Excel | Excel Discussion (Misc queries) | |||
Removing "Save As" Command from an excel file. | Excel Worksheet Functions |