| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants or Precedents on a protected sheet
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative for Trace Precedents | Excel Discussion (Misc queries) | |||
| Trace dependants/precedents from another worksheet | Excel Discussion (Misc queries) | |||
| Can I trace dependants for a multiple selection? | Excel Discussion (Misc queries) | |||
| Trace Dependants Not Working... | Excel Worksheet Functions | |||
| Trace Dependants | Excel Discussion (Misc queries) | |||
Linear Mode
