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