Hello

I have a workbook that is shared with many users and it can NOT be password protected but I want to control the data in cells F45 and G45. The VB I have works for F45 but I cant duplicate it for cell G45


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target = Cells(45, 6) Then Cells(45, 6) = "n/a"
End Sub

Currently when ever someone enters anything in cell F45 it changes back to n/a as soon as they press enter.