When an Excel Workbook opens, if cell A1 in Sheet1 contains nothing I
want Excel to run Macro1.
If cell A1 in Sheet1 contains the text "Hello", I want Excel to do
nothing.
I've tried this:
If (Sheet1)A:1 = "Hello"
Then
Range("A1").Select
Else
Macro1
End If
but
VB gives me the red pen for the first two lines.
Any ideas?
Kind regards
Ian M