Removing or deleting Checkboxes from workbook
 

Sorry, apparently not all the Checkboxes are pictures. The subroutine did
remove some artifacts, but left the nasty ones. The reason I want to get rid
of them: After cutting and pasting, which lost some (retrievable) data, the
Workbook size shrank from 4+ MB 387KB and Open and Closes in a few seconds as
opposed to 10-15 minutes!
--
Brian McNamee


"ryguy7272" wrote:

I think you should import that data so you don't have all that HTML stuff.
Take a look at this:
http://www.mrexcel.com/tip103.shtml

As for deleting the HTML stuff, try this:
Sub DeleteWebObjects()
Cells.Hyperlinks.Delete
ActiveSheet.Pictures.Delete
End Sub

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Brian E McNamee" wrote:

After copying data off the web into Excel I get lots of HTMLCheckboxes which
I don't want and bloat the wookbook slowing down loading, processing, and
saving. Any suggestions on deleting all checkboxes??
--
Brian McNamee