ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auditing protected worksheets (https://www.excelbanter.com/excel-programming/352836-auditing-protected-worksheets.html)

Dean[_8_]

Auditing protected worksheets
 
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

Auditing protected worksheets
 
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



Dean[_8_]

Auditing protected worksheets
 
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





Tom Ogilvy

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








All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com