Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect sheet, yet allow Auditing?€Ž
In Excel 2003 you can go to TOOLS PROTECT, and obviously protect the sheet.
However when you do so, the formula auditing toolbar becomes ghosted. Is it possible for it not to be ghosted ? I note there are the tick boxes in the Protect dialog box, but none seem to relate to Auditing. Can someone please help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect sheet, yet allow Auditing?€Ž
The point of protecting the auditing functionality is so people can't see
your formulas, often the formulas that people have in sheets that need protection are much more valuable than raw data.Allowing people to view all of that would miss the point. -- -John Please rate when your question is answered to help us and others know what is helpful. "Phil Davy" wrote: In Excel 2003 you can go to TOOLS PROTECT, and obviously protect the sheet. However when you do so, the formula auditing toolbar becomes ghosted. Is it possible for it not to be ghosted ? I note there are the tick boxes in the Protect dialog box, but none seem to relate to Auditing. Can someone please help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect sheet, yet allow Auditing?€Ž
you can unlock the cells you want to audit and that should do it. this only
applies to the unlocked cells though. -josh "John Bundy" wrote: The point of protecting the auditing functionality is so people can't see your formulas, often the formulas that people have in sheets that need protection are much more valuable than raw data.Allowing people to view all of that would miss the point. -- -John Please rate when your question is answered to help us and others know what is helpful. "Phil Davy" wrote: In Excel 2003 you can go to TOOLS PROTECT, and obviously protect the sheet. However when you do so, the formula auditing toolbar becomes ghosted. Is it possible for it not to be ghosted ? I note there are the tick boxes in the Protect dialog box, but none seem to relate to Auditing. Can someone please help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect sheet, yet allow Auditing?€Ž
Thanks for both your help.
Yes good point of course to proper intellectual property. Will also try the unlocked cell thing - see if that's acceptable at work Many thanks! "JoshC" wrote: you can unlock the cells you want to audit and that should do it. this only applies to the unlocked cells though. -josh "John Bundy" wrote: The point of protecting the auditing functionality is so people can't see your formulas, often the formulas that people have in sheets that need protection are much more valuable than raw data.Allowing people to view all of that would miss the point. -- -John Please rate when your question is answered to help us and others know what is helpful. "Phil Davy" wrote: In Excel 2003 you can go to TOOLS PROTECT, and obviously protect the sheet. However when you do so, the formula auditing toolbar becomes ghosted. Is it possible for it not to be ghosted ? I note there are the tick boxes in the Protect dialog box, but none seem to relate to Auditing. Can someone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros and protect sheet | Excel Worksheet Functions | |||
How to protect all sheet ? | Excel Worksheet Functions | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
help with protect sheet | Excel Discussion (Misc queries) |