Code for call subs when a particular worksheet is opened

[Ruthanne]

Hi all,
Thank you in advance for your great support over the years!
I would like to have code that calls 3 subs when worksheet named "4 GN-MISC" is opened but I don't know where to put it (in the module or in the worksheets "view source"?) or how to write the code for that change event.
I would much appreciate help with this! I have searched the forum & the internet but haven't been able to figure it out. Thanks!

 

[VoG]

Try like this in the worksheet's code module

Private Sub Worksheet_Activate()
Call macro1
Call macro2
Call macro3
End Sub

 

[Ruthanne]

Why you Salty Dog! Cheers to you! Thanks so much!