Trace dependents in protected sheet

[Ken]

I have a worksheet where I would like the users to be able to use Trace
Dependents. However, when I protect the worksheet this is no longer possible.
So I was was wondering whether it is possible to create a macro which allow
you to use Trace Dependents when a worksheet is protected?

Thanks
Ken

 

[JLGWhiz]

You would have to include in your code a temporary removal of the sheet
protection, with password and unprotect statements. Then reinstate the
protection after you do the precedent test. Pretty tricky setup.