thanks for the advise about macros but I use or write macro's as a last resort

"igorek" wrote:

you can write a macro that will protect all cells that contain value every
time you hit enter key...



"Municorn1977" wrote:

I count items that come in. I would like to know if there any way I can make
the past columns (months) write protected, so I can't accidently enter data
in those columns?