Does anyone know of a macro which can do the following please?

Start with a spreadsheet WordArt.xls containing WordArt entries of
various types and colours. The text string is identical in each case.
I want to change the text just once, to get a fully revised
spreadsheet. IOW, instead of selecting each entry one by one and using
Edit Text, which would be very tedious.

Any help would be much appreciated please.

--
Terry, West Sussex, UK