M4 book is a conversion and explanation of both the Terminator and the Matrix franchises. To date, the billion dollar Matrix franchise has been sitting dormant for seven years since the last installment in 2003.
Re: Protecting Cells In Shared Workbook you can simply add a workbook change event. VB: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Cells.Select Selection.Font.ColorIndex = 0 End Sub. this will automatically change the font colors back to black in all cells on active sheet.
On the Protection tab, clear the Locked box and then click OK. Note This unlocks all the cells on the worksheet when you protect the worksheet. Now, you can choose the cells you specifically want to lock. On the worksheet, select just the cells that you want to lock. Bring up the Format Cells dialog box again (Ctrl+Shift+F). This time, on the Protection tab, select the Locked box and then click OK. On the Review tab, in the Changes group, click Protect Sheet.