For more information about handling events, see NIB: Consuming Events.

Data Grid View Cell Validating Event Handler Data Grid View Cell Validating Event Args Cell Validated Data Grid View Cell On Cell Validating Data Grid View Class System.

B) Excel only performs validation on single cells and not on paste actions. I can solve problem A for you; I think you will need VBA to do custom validation for problem B.

See the links at the bottom of this post for some ideas; I'm not a pro at VBA so I can't really say which will work for you.

Having read a number of the Excel forums and the MS help boards on this issue, I can tell you that it's really TWO problems: A) a standard copy-paste in Excel copies the validations from the source to the destination.

If you don't have any safeguards, this wipes out the validation from your special column when a user pastes into it.

Those custom functions can access the selection affected by the paste, and fire validation rules/custom subs on it immediately.

For examples of this functionality, try this guide (especially the section farther down titled "Validation").The default rights for a user in a protected sheet are pretty minimal.If your users need a lot of rights, like the ability to delete rows, just enable the rights they need in the Protect dialog by checking the checkboxes.but it can be easily fooled or bypassed by pasting (Ctrl V) data from other source.So how can i protect to user can't enter wrong data or outside from my validation list.now, the grid cell for example double type, errors when the user left it empty and does not let user to go to the other cells. i need to user to freely go to the different cells and only caugh on the inputting wrong datatype forexample inputting string instead of double (not lefting a double cell empty). also i need to check the cells manually and under certain circumestances, change the color of dell border to be red and else black. Note, that it can be used when the validation is performed through the IData Error Info or INotify Data Error Info interfaces.