clearing sheet including form control

[lezawang]

Hi
I have Form Controls in my sheet like Checkbox, Options buttons etc. I want to clear the sheet from everything including the form controls. I used this code

workbooks(1).worksheets(1).cells.clearcontents

But that did not clear Form Controls! Any help please. Thanks

 

[dmt32]

Try

    With Workbooks(1).Worksheets(1)
        .Cells.ClearContents
        .DrawingObjects.Delete
    End With

Dave