Objective: To remove textbox from worksheet
Concern: Each time I have tried to do this a different number appends to the Object TextBox. I need the textbox to be generic so that I can call in the future and delete it without knowing its specific name.
Any help would be appreciated.
Concern: Each time I have tried to do this a different number appends to the Object TextBox. I need the textbox to be generic so that I can call in the future and delete it without knowing its specific name.
Code:
Sub removeTextBox()
'
' Objective: To remove textbox from worksheet
'
'
Sheets("pricing").Unprotect
Sheets("Pricing").Shapes.Range(Array("TextBox 5")).Select
Selection.Delete
End Sub
Any help would be appreciated.