Locking by multiple users possible?
 

Hi guys.

I have a spreadsheet that needs to be sent to regional offices so they can populate some figures. There is information on the spreadsheet that I don't want them to change so I have locked 'my' cells and protected the worksheet.

Once they have populated their figures, I want them to be able to somehow lock 'their' cells before they forward the spreadsheet to their stores, leaving another range of cells unlocked for the stores to populate.

So in effect there are three stages of data input and stages one and two need to be locked independently.

Is there any way to do this on a single spreadsheet/workbook so that various users can enter info and then lock it before sending forward?

Many thanks
Neil