Hi David,

Is there anyway to do a find and replace not just in
cells but also textboxes, shapes, headers/footers etc?


Yes, use my FlexFind.zip from

http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.htm

Make sure you check the "Objects" checkbox.

Regards,

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