Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to enable formula auditing in a protected worksheet?
I want the worksheet to be protected, primarily to prevent users from
disabling validation. But, I also want users to be able to copy/paste data which negates the validation process (ie., they don't get the error message). If I could enable formula auditing (specifically 'circle invalid data') AND protect the worksheet then the user could see what they copied/pasted that was in error. Requirements: Users must be able to copy and paste Don't want users to be able to change the data validation edits OR delete/insert columns That's it. Any advice? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable outlining in a protected worksheet | Excel Discussion (Misc queries) | |||
Allow formula auditing for users in a protected worksheet? | Excel Discussion (Misc queries) | |||
Formula auditing on protected sheets | Excel Discussion (Misc queries) | |||
enable autofilter in a protected worksheet in Excel 97 | Excel Worksheet Functions | |||
How to enable font color on protected worksheet? | Excel Discussion (Misc queries) |