Oliver Brinzing wrote:
I have a problem using cut & paste on non protected cells (input area) on
password protected sheets:
Example:
A user insert values into non protected cells to do some calculations.
The sheet is password protected, the user can not change the formulas.
Now the user uses cut (strg x) on a non protected cell and paste the content
via (strg v) into another non protected cell ...
This will change the referenced cells of the formulas .... and the formular
results are wrong ...
This is a general problem and seems to affect all documents...
Would'nt it make sense to disable "cut" on password protected sheets ?
Disabling it only on the protected sheet wouldn't be enough, a protected
formula might as well depend on cells on non-protected sheets. Also,
it's not only cut & paste, but also stuff like drag & drop and
inserting/deleting cells.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
