Macro help
Hi Chuck,
The tickmarks are a toolbar from a program I use . The macro I used works
great except it takes out the text boxes. I am new to macros and haven't a
clue what to do to make the tickmarks disappear and the text boxes to stay.
Any help will be greatly appreciated.
--
thank you mac
"CLR" wrote:
Please describe the procedure you used to originally create the "tickmarks".
Vaya con Dios
Chuck, CABGx3
"mac" wrote:
Hello,
I have a macro (below) that removes all tickmarks, but it also removes text
boxes with data in them. Is there a way to remove all tickmarks but leave
the text boxes alone.
Any help will be appreciated.
Sub RemoveShapes()
Dim wks As Worksheet
Dim shp As Shape
For Each wks In Worksheets
For Each shp In wks.Shapes
shp.Delete
Next shp
Next wks
End Sub
--
thank you mac
|