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.
Re: Protecting Cells In Shared Workbook I have a similar issue but with a twist. I need to protect cells which my team members can't edit and only the manager can and at the same time the work book is shared hence ... Excel Video Tutorials / Excel Dashboards Reports.