Trace dependents in protected sheet

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
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.
 
Back
Top