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.
Lock only specific cells and ranges in a protected worksheet. 1  If the worksheet is protected, do the following: On the Review tab, in the Changes group, click Unprotect Sheet. The Protect Sheet command changes to Unprotect Sheet when a worksheet is protected. 2  Select the whole worksheet by clicking the Select All button.