Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Groups and Protected Worksheets - know if protected | Excel Discussion (Misc queries) | |||
how to enable formula auditing in a protected worksheet? | Excel Worksheet Functions | |||
Allow formula auditing for users in a protected worksheet? | Excel Discussion (Misc queries) | |||
Formula auditing on protected sheets | Excel Discussion (Misc queries) | |||
Protected Worksheets | Excel Programming |