I'm in the process of validating an excel spreadsheet. The question has been
raised about how we prove that the cells containing the calculations within
the spreadsheet are actually protected. It would be possible to go thru each
individual calculation cell and attempt to type something into it, thereby
causing the error message box to appear, then screenprint it. However, the
spreadsheet has something in the region of 150 calculation cells, so this is
an impractical solution. What I need is a method by which Excel can be made
to list all of the protected cells within the spreadsheet, but this must be
driven by Excel itself, rather than something which amounts to me just
creating a range/list of cells myself. Can you help?

Thanks in advance

Jo