Sub TryNow()
Dim mySht As Worksheet
Set mySht = ActiveSheet
mySht.Shapes.SelectAll
Selection.Delete
End Sub

--
HTH,
Bernie
MS Excel MVP


"aftamath" wrote in message
...
Whats the VBA code to delete all the shapes on a worksheet?