Trace dependants or Precedents on a protected sheet

H

Hervinder

I have a workbook which is protected, the problem i have is that the person
using wants to be able to use the trace dependants and precedants buttons on
formulas. But the protect does not allow it.

Is it possible for me to protect the sheet and allow the user to trace
dependants and precedants on formulas?
 
L

Luke M

99% no.

You can't trace dependents or precedents in a protected sheet. Using the
keyboard shortcut of Ctrl+[ you can select the direct precedents (however
Ctrl+], Ctrl+Shift+[, and Ctrl+Shift+] will all cause errors. Apparently
doesn't want to think that hard in a protected sheet).
 

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 dependants/precedents from another worksheet 7
Can I trace dependants for a multiple selection? 2
Reference list 2
Data Validation drop down not showing and Formula Auditing bar greyedout 2
need a complete list of Precedents and Dependents 2
Alternative for Trace Precedents 4
trace all dependents 1
is it possible to do this? for income tax withholding 2

Top