Remove calendar control

G

goss

Hi ng.
Using xl xp pro
Added cal control 10 to my wrksheet
Can't select to delete
How do I remove

tia
goss
 
T

Tom Ogilvy

if it is the only controls

Sub RemoveControl()
activesheet.shapes(1).Delete
End Sub

Make sure the sheet isn't protected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top