View Single Post
  #1  
Old December 23rd, 2009, 02:47 PM posted to microsoft.public.excel.misc
mike
external usenet poster
 
Posts: 3,942
Default Macro (password)

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