How can I delete ALL text boxes in Excel worksheets?
 

Somehow we have hundreds of text boxes, which you can not locate unless you
are lucky enough to select one. Then we can remove them, is there a way to
remove ALL text boxes easily?

Hi Genesis,

Then we can remove them, is there a way to
remove ALL text boxes easily?


F5, special, Objects, del?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

a macro
Sub shapescut1() 'Tom Ogilvy
ActiveSheet.Shapes.SelectAll
Selection.Delete
End Sub

--
Don Guillett
SalesAid Software

"Jan Karel Pieterse" wrote in message
...
Hi Genesis,

Then we can remove them, is there a way to
remove ALL text boxes easily?


F5, special, Objects, del?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Works great. Thank you.

"Jan Karel Pieterse" wrote:

Hi Genesis,

Then we can remove them, is there a way to
remove ALL text boxes easily?


F5, special, Objects, del?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com