The point of protecting the auditing functionality is so people can't see
your formulas, often the formulas that people have in sheets that need
protection are much more valuable than raw data.Allowing people to view all
of that would miss the point.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Phil Davy" wrote:

In Excel 2003 you can go to TOOLS PROTECT, and obviously protect the sheet.

However when you do so, the formula auditing toolbar becomes ghosted. Is it
possible for it not to be ghosted ?

I note there are the tick boxes in the Protect dialog box, but none seem to
relate to Auditing.

Can someone please help?