View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Auditing protected worksheets

Only check the contents box.

--
Regards,
Tom Ogilvy

"Dean" wrote in message
...
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" wrote in message
...
Don't believe there is any option for this. Did you just protect

contents
and try it.

--
Regards,
Tom Ogilvy

"Dean" wrote in message
...
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