View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
igorek igorek is offline
external usenet poster
 
Posts: 38
Default How do I make a column not allow new data for monthly report?

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?