Modify delete to allow only single row deletions?

[Jaymond Flurrie]

How could I prevent a user from deleting nothing but entire rows? I user tries to delete for example entire column, I'd like to just do something like:

MsgBox "Deleting anything else than one row at a time has been disabled", 16

 

[Michael M]

Have a look at Tools / Protection
and check the delete rows box.

 

[Jaymond Flurrie]

I think that does enough for me, thanks!