Hi, below I have VBA for worksheet change. But I want it only to run on 1 sheet, not across all sheets.
What do I need to change to make it run for a specific sheet name.
Private Sub Worksheet_Calculate()
Static oldval
If Range("F3").Value <> oldval Then
oldval = Range("F3").Value
' 'Run next photo
Call cmdDisplayPhoto_1_Click
End If
End Sub
Thanks
What do I need to change to make it run for a specific sheet name.
Private Sub Worksheet_Calculate()
Static oldval
If Range("F3").Value <> oldval Then
oldval = Range("F3").Value
' 'Run next photo
Call cmdDisplayPhoto_1_Click
End If
End Sub
Thanks