Yes there is and it is called an event.
Right-click the sheet, select view code and insert something like:

Private Sub Worksheet_Activate()
MsgBox ("Hello world")
End Sub

Per Erik

wrote:
Hi, is there some macro command in Excel VB with is triggered when a
given worksheet is opened? If so what's the syntax? Many thanks in
advance.