|
Posted to microsoft.public.excel.misc
|
|
|
Preventing copy/paste on validated cells
Make use of JW tip:
http://j-walk.com/ss/excel/tips/tip98.htm
micky
"mbp" wrote:
Hi
I've got a column of cells with validation.
If a user instead of typing values into the cells, copy/paste from another
cell, the origial validation settings are overwritten.
Is there any way to prevent the user to do this, otherwise validation is not
worth much.
|