I have a spreadsheet that I have to share with my colleagues. They have to
input information into columns 'J-M' and possibly column 'A'. If they are
entering info. for a new item (which was not originally on my spreadsheet)
then they need to insert new rows so as to enter the item data in Column A. I
did try locking the whole worksheet except Column 'J-M' and alowing them to
Insert Rows with the 'Protect Worksheet' function, but that blocked them from
entering new item data as Column A was locked. I do not want to unlock Column
A as I do not wish the integrity of the old tems in Column A to be affected.
I use Excel 2003. Please help.