Want to work with us? We're on the lookout for digital experts.

We're hiring

Clearing html check boxes from excel

Web Bureau

17 February 2016 by Web Bureau

This has happened to me before on many occasions and I've just give up.

  1.  Gone to my new web application and copied and pasted some data into excel
  2. Big problem the data has copied across a load of check boxes into excel.
  3. Give up and try something else...

This time I decided to take a stance and it was very easy:

  1. In the spreadsheet click ALT + F11 
  2. Paste in the following code - (below)
  3. Press the play button
  4. Close the vba screen down by X out of it
  5. Voila! All the check boxes are gone


Sub DeleteObjects()
    Dim obj As Object
    For Each obj In ActiveSheet.Shapes
End Sub


Grow your businessStart a project with us today.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.