View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Trace dependants or Precedents on a protected sheet

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).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hervinder" wrote:

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?