Private Sub Worksheet_Activate()
'do your stuff
End Sub


Gord Dibben MS Excel MVP

On 17 Feb 2007 11:41:19 -0800, 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.