Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've added a few ActiveX calendar controls and now can't removed them. The calendars won't select so that I can remove them. You can see from the video how I've went to design view and tried to select the calendars to no avail.

http://screencast.com/t/jAJSmmemW

share|improve this question

2 Answers 2

If these are the only shapes in the worksheet, try the following VBA code:

Sub Macro1()
    Dim x As Shapes, y As Shape

    Set x = ActiveSheet.Shapes
    For Each y In x
        y.Select
        Selection.Delete
    Next y

End Sub

To enter the code. Press alt-F11, from the menu choose Insert\Module and then paste this code into the code area. Click somewhere inside the code, then press F5 to run the code.

It will delete ALL shapes from the active worksheet.

share|improve this answer

It looks like in your screen capture that you select design mode at the beginning of the process enter image description here after inserting the calendar controls you no longer are in design mode

enter image description here so the items are not selectable

Reselect design mode so you can delete them

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.