Trace dependents in protected sheet

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trace dependents 1
Reference list 2
Trace Dependents not working 3
trace all precedents or dependents 6
Unable to trace dependents and file shows "Calculate" all the time 2
Trace Dependents 8
highlights cells that are not a dependents 14
Trace dependents 10

Top