vettetax
New Member
- Joined
- Jul 5, 2006
- Messages
- 47
I've tried conditional formatting. I've tried various Protection techniques.
I need my users to input in Yellow, unprotected cells only. The worksheet is protected. But the input cells are not. However, some users have managed to copy protected cells into unprocted cells screwing up the process for everyone else. I want to allow my users to use the copy function, therefore I want them to be able to copy protected cells into the yellow, unprotected cells, but without messing with the unprotected cell's formatting. Simply explaining the copy/paste special/values function is just not enough. Is there a way to 'lock' a cell's format?
I need my users to input in Yellow, unprotected cells only. The worksheet is protected. But the input cells are not. However, some users have managed to copy protected cells into unprocted cells screwing up the process for everyone else. I want to allow my users to use the copy function, therefore I want them to be able to copy protected cells into the yellow, unprotected cells, but without messing with the unprotected cell's formatting. Simply explaining the copy/paste special/values function is just not enough. Is there a way to 'lock' a cell's format?