VBA Show Form on load

[blossomthe2nd]

Hi Guys

Im relatively new to this , I have a form with a Macro attached , I wish to show this form (frmUpdater) when my worksheet "Holidays" opens.

Can anyone help me with this ?

Thanks

 

[VoG]

Try this: right click the Holidays tab, select View Code and paste in

Private Sub Worksheet_Activate()
frmUpdater.Show
End Sub

 

[blossomthe2nd]

Hey VoG

Thanks a million works perfectly