Hi Jigs,

This might work:

Sub Shapes1()
'Delete all Objects except Comments
On Error Resume Next
ActiveSheet.DrawingObjects.Visible = True
ActiveSheet.DrawingObjects.Delete
On Error GoTo 0
End Sub


Ewan.

"jigs d" wrote:

hi all,
i have written code in macro which will dynamically add combo box and its
events when worksheet gets activated.
now i want that when worksheet gets deactivated, all the dynamically created
combo box shd be deleted.

please suggest me something.
any help will be greatly appreciated
thanks .
jigs d