One of the functions that is not available when a worksheet is protected is
the Audit Tools - Precedents and Dependents

These functions are quite useful. Does anyone know of any way or tools to
still allow ausit tools when the worksheet is protected.?

Have tried various addins without success as the worksheet protection
inhibits their use

thanks

If the worksheet is protected then, presumably, you are the end-user, in
which case the author has probably protected it for a good reason.

If you are the author, then why not unprotect is so you can use these tools?

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"STCOL100" wrote in message
...
One of the functions that is not available when a worksheet is protected
is
the Audit Tools - Precedents and Dependents

These functions are quite useful. Does anyone know of any way or tools to
still allow ausit tools when the worksheet is protected.?

Have tried various addins without success as the worksheet protection
inhibits their use

thanks