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.
Method 1 Lock and Protect Cells: Excel 2007 and Excel 2010. Open the Excel spreadsheet that contains the cells you want locked. Select the cell or cells you want locked. Click on the tab labeled Review at the top of your Excel spreadsheet. Click on the button labeled Protect Sheet from within the Changes group.