VBA Code to pretect certain range of sheet with some features

[m_aatif]

I have a sheet named " sheet1".My data is from row A1 to E20. some cells have data validation as well. I need code which performs following control tasks.

1) User should not be able to add / delete any row or column in the range A1 to E 20.
2) Wherever i have data validation in any cell, user should be able to select from data validation only. should not be able to enter anything manually.
3) In column B, user should be able to enter text and numeric as well.
4) In column A,C,D &E, user should be able to enter numbers only.


Thanks
Atif

 

[baitmaster]

most of this is just straight Data > Validation settings, coupled with Worksheet Protection

The biggest problem is that Data > Validation can be pasted straight over using simple copy/paste. You could use application.cutcopymode = false to prevent this, triggered by the "worksheet selection change" event if someone selects within your restricted area - but your Users might want to be able to copy/paste, and it relies on macros being enabled

A better approach might be to include basic formulas that report any errors entered. I'm not convinced that VBA is the way to go in this case