Pasting and still preserving formats/Validation

[Hari]

H

Please excuse me for doing multiple posts on this matter. I didnt explain the issue properly earlier
I want people to paste data in such a way that my formatting/validation (F/V) is not lost. Presently folks can overwrite my F/V by doing a copy, paste from another worksheet. Its like I want people to have the capability to type in a value/number or use paste special values but do it in such a way that my F/V is not lost/breached
If I password protect the cells then they cannot type/paste and if I dont password protect then Im in danger of losing my F/V. Im keen on validation because I dont want anybody to paste names in a column which is supposed to have dates and so on.Please tell me if there is a way out. ( I dunno Vb, If there is a method which doesnt use Vb, i will be greatful ...

Har
India

 

[Dave Peterson]

This might not be the response you want, but have you thought about just
dropping your formatting and data|validation and putting all that stuff in code?

You could allow the users to put anything they want in the worksheet, then
validate it. And format it the way you want.

Depending on how many different validation rules you have, it might be easy or
difficult.

But as long as macros are enabled and events are enabled, you may find it more
robust.