I am trying to do something relatively simple using VBA but the code I wrote
is not responding. I am trying to have cell "C16" record or 'log' the date
(and the time if anyone knows how to do this) that cell "C13" is changed to
"Y". Here is my code:

Private Sub Workbook_Open()
CloseLog = Worksheets("Administrator").Cells("C13")
If CloseLog = Y Then
With Worksheets("Administrator").Cells("C16")
.Value = Date
.NumberFormat = "mm/dd/yyyy h:mm AM/PM"
End With
End If
End Sub

Thanks in advance,
IP