This Workbook Startup Tab

[jayjaysb]

Hi all, I have a spreadsheet upon opening, it comes up with a message. I also want the spreadsheet to open on a specific tab, if I put it below the message, it doesn't work (see below). Please advise thanks JJSB

PrivateSub Workbook_Open()
<code style='margin: 0px; padding: 0px; border: 0px currentColor; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; vertical-align: baseline;'> MsgBox ("Your message goes here")
</code>EndSub
Private Sub Workbook_Open()
Sheets("guidance").Activate
End Sub

 

[MARK858]

You need to put it in the same sub.

PrivateSub Workbook_Open()
 MsgBox ("Your message goes here") 
 Sheets("guidance").Activate
 End Sub

 

[jayjaysb]

Jeez, DUH!!! I am an el THICKO lol, Much obliged Mark858