View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Remove calendar control

if it is the only controls

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

Make sure the sheet isn't protected.

--
Regards,
Tom Ogilvy

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

tia
goss