VBA code to prevent data entry

**singhabhijitkumar** · 02-04-2010, 01:52 AM

I want to prevent users from entering data into a column. but if they want to delete a row it should be allowed. How can i do this?

**amulee** · 02-04-2010, 01:58 AM

Maybe you can try such Code

Please Login or Register  to view this content.

**teylyn** · 02-04-2010, 02:06 AM

No VBA required, if you want to avoid it. Lock the cells of the column, unlock the cells you want to remain editable and then click the Review ribbon - Protect Sheet - tick the "Delete rows" option.

**contaminated** · 02-04-2010, 02:37 AM

U can also set data validation. Select entire column, go to data > validation. select custom from Allow drop-down. type ="" in formula field
Thus, u can prevent entering any data in column, but allow to delete entire row.

hi Teylyn. I didn't check, but I dont believe your suggection would work...

**teylyn** · 02-04-2010, 03:05 AM

caught me out there, V. You're right. Thanks for pointing it out.

**singhabhijitkumar** · 02-04-2010, 03:22 AM

hi thanks its working very well.
Wanted to know if you can also help me with the following:
I want to prevent users from entering characters in number fields, and entering incorrect date in date field. the date entered should be converted to DD-MON-YYYY format.