cell protection

[bigbob]

Hi,
I have a spreadsheet to track peoples holidays .Each person has a separate column and there is a list of dates down yhe left hand side .I enter into the cell a code for the type of absence and at the top of the sheet I have vaious formulas to see current totals .It is very easy to overwrite a previously entered code if you are entering a fortnights worth of holidays and I would like to know if there is some way of protecting the cells contents without going to that specific feature of Excel as the worksheet will be updated on a regular basis
Thanx in advance
Bigbob

 

[Ampleford]

This would only work if all the rows in each column are completed...

If you were to record a macro which would do the following steps :-

1) unprotect the sheet
2) take a column at the top row and use CTRL+Shift+Down to highlight the cells filled in that column
3) Use "Format, Cells, then Protection" to protect the cells
4) work your way along the columns one by one
5) protect the sheet

that would work - its a little long winded, but it would only need to be actually done once - from then on the macro could just be run...


is this any help ?