ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Audit Tools with Worksheet Protection (https://www.excelbanter.com/excel-discussion-misc-queries/39813-using-audit-tools-worksheet-protection.html)

STCOL100

Using Audit Tools with Worksheet Protection
 
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

Andy Wiggins

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





All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com