How do I make a column not allow new data for monthly report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
you can write a macro that will protect all cells that contain value every
time you hit enter key...
 
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?
Click to expand...

Select the whole sheet then go Format|Cells|Protection|Deselect the
Locked option|OK.

To select the whole sheet click on the blank box above the Row 1 label
and to the left of the Column A label.
If Row and Column labels are not visible then select A1 hold down both
Shift and Ctrl keys while sequentially pressing the Right Arrow key
then the Down Arrow key.

Select the cells you don't want to accidentally change then go Format|
Cells|Protection|Select the Locked option|OK.
Apply sheet protection by going Tools|Protection...|Protect Sheet|OK.

When you need to increase (or decrease) the range of cells to be
protected against accidental change...

Go Tools|Protection|Unprotect sheet first, then select the range of
cells that are to be included in the protected range (or removed from
the protected range), then go Format|Cells|Protection|Select the
Locked option (or deselect the Locked option)|OK, then reapply sheet
protection by going Tools|Protection|Protect Sheet...|OK.

Ken Johnson
 
thanks Ken that did just what I wanted it to do

Ken Johnson said:
Select the whole sheet then go Format|Cells|Protection|Deselect the
Locked option|OK.

To select the whole sheet click on the blank box above the Row 1 label
and to the left of the Column A label.
If Row and Column labels are not visible then select A1 hold down both
Shift and Ctrl keys while sequentially pressing the Right Arrow key
then the Down Arrow key.

Select the cells you don't want to accidentally change then go Format|
Cells|Protection|Select the Locked option|OK.
Apply sheet protection by going Tools|Protection...|Protect Sheet|OK.

When you need to increase (or decrease) the range of cells to be
protected against accidental change...

Go Tools|Protection|Unprotect sheet first, then select the range of
cells that are to be included in the protected range (or removed from
the protected range), then go Format|Cells|Protection|Select the
Locked option (or deselect the Locked option)|OK, then reapply sheet
protection by going Tools|Protection|Protect Sheet...|OK.

Ken Johnson
Click to expand...
 
Back
Top