Macro help
Hi Carim
It does not do anything.
--
thank you mac
"Carim" wrote:
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
|