I'm trying to get a macro (named Refresh) to run whenever a worksheet is
opened. I've tried using
Private Sub Worksheet_Activate()
Refresh
End Sub

as was suggested in other posts, but this doesn't seem to work.