Have noticed in Excel (97) that CTRL-F (i.e find) will search the values of cells on the sheet, but does not search any text boxes on the page. I've been asked to write some code that trawls through a large report set up in Excel (that uses large text boxes for the text of the report) for a series of words and phrases.
However CTRL-F is disabled for looking in text boxes.
So any ideas how I might achieve this?
And as an addition (though less important) how to search graphs for the text as well.