Auditing protected worksheets

[Dean]

When I protect the sheet, I notice that a user cannot even use trace dependents. To me, this seems silly. Is there anyway to still allow such auditing without having to turn protection off (since they won't be given the password)?

Thanks!
Dean

 

[Tom Ogilvy]

Don't believe there is any option for this. Did you just protect contents
and try it.

--
Regards,
Tom Ogilvy

When I protect the sheet, I notice that a user cannot even use trace
dependents. To me, this seems silly. Is there anyway to still allow such
auditing without having to turn protection off (since they won't be given
the password)?

Thanks!
Dean

 

[Dean]

I'm not sure how you do something more austere than "just protect contents",
if indeed I am doing something like that. I just did protect sheet and
checked all the boxes. Kindly explain.

Thx,
Dean

 

[Tom Ogilvy]

Only check the contents box.