Thread
:
Macro help
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Carim
external usenet poster
Posts: 510
Macro help
Hi mac,
Test it as a macro on its own :
Sub Delete()
Dim i As Long
For i = 1 To ActiveSheet.OLEObjects.Count
If TypeName(ActiveSheet.OLEObjects(i).Object) < "TextBox" Then
ActiveSheet.OLEObjects(i).Delete
End If
Next i
End Sub
HTH
Carim
Reply With Quote
Carim
View Public Profile
Find all posts by Carim