I have added shapes to my worksheet from VBA using the following code:
With .AddShape(msoShapeRectangle, tlh1, tlh2, brh1, brh2)
.ForeColor.RGB = RGB(200, 200, 200)
.BackColor.RGB = RGB(200, 200, 200)
This appears to work well, but I need to be able to remove all the shapes on the worksheet using a button_click().
I have also placed textboxes using addtextbox(etc..) so I must remove these at the same time.
hope someone can help.