Tue 2 Sep 2008, 15:56Delegate Linda said...
Linda has attended:
Excel Intermediate course
Chart protection
how do i protect a worksheet and then allow part access for colleagues
Thu 4 Sep 2008, 12:47
Edited on Thu 4 Sep 2008, 12:49Trainer Carlos said...
Worksheet protection
Hi Linda
Sorry for the delay in answering this question.
One of the possibilities in Excel is to lock the spreadsheet from change but leave some parts unlocked. To do this:
1. On the worksheet highlight the cells to be unlocked.
2. Select the Format menu and click Cells.
3. In the Format Cells dialog box click the Protection tab and uncheck the Locked check box. Click OK.
4. Select the Tools menu, Click Protection and the click [b]Protect Sheet
