delete coding for excel 2007
 

Hello,

I have a workbook that contains about 50 sheets. Within the the sheets I am
looking for a name anywhere within a cell - for example "Susan" I want to
delete everything from the sheets except the cells that are protected and
only showing "Susan". Can this be done? Advice or visit a web site will be
appreciated. Thank you in advance.