cell C300 when any data is entered into this cell it will change Tab colour
now what i want is to enter QC only so that the Tab colour will change on
each sheet (I do have 52 sheets for this workbook) to indicate sheet is
complete & the macro i used does not allow for this I need help !!

"Jim Thomlinson" wrote:

Cells don't have passwords. Sheets have passwords. Cells are just locked or
unlocked Locked cells are not editable if the sheet is password protected.

So what exactly do you want?
--
HTH...

Jim Thomlinson


"Mike" wrote:

I have this macro now i would like to set this cell with a password is this
possible

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Range)
If Intersect(Target, Range("C300")) Is Nothing Then Exit Sub
ActiveSheet.Tab.ColorIndex = 15
End Sub