Trigger event

[Pastor Del]

I've got experience with VBA in Access but I'm new to Excel with VBA. Where do I put my macros so they will be triggered by an event? Specifically I'm looking for a way to trigger the execution of this code when the worksheet is opened.

If IsEmpty(Range("c25")) Then
Range("c25") = Now()
End If

 

[gsistek]

Welcome to the forum!

Just put this into the "This Workbook" window in the VBA editor.

Private Sub Workbook_Open()
If IsEmpty(Range("c25")) Then
    Range("c25") = Now()
End If
End Sub

 

[Pastor Del]

Thanks. I put that code in just about every other window - don't know why I missed that one.

Thanks again