it is basically the same sheet that you helped out with the other day. Only I had added afew rows above the row that has the actual column headings.....Description, date etc etc.

The Columns inserted above this column just include reference cells that identify if a cell is color coded....and who would have done that item....I aslo added a box to count items....based off the formula that you provided last week.

All of this stuff down to my title row.... should always be visible.....and I have no trouble Freezing the row below my title row as long as it is not shared and protected......and even once it is done, it will often work for a while as it is supposed to.

Typically the problem is that the entire sheet will freeze on one of us.....so that you can not even scroll to the end of the sheet. the only way to do this is to unprotect the sheet...unfreeze...and then freeze the row under the title row.....then re protect....the real pain is that you must also make sure that all users are out of the sheet before you unprotect the sheet...plus typing the passwords and all that.

It would be nice to be able to Freeze and unfreeze in protected shared mode.


We had done this because we have people that have access to this information, and will look at it to see were items are at in the process.....and some have been sorting info....this has resulted in cells being changed and all kinds of trouble with data integrity