Userform to open when spreadsheet opens

[jammoca]

I have a spreadsheet that on opening, I want a userform called "NewGame" to open in front of it.

I am currently using the following code, but the spreadsheet is opening without the "NewGame: userform appearing.

Private Sub Userform_Activate()
With NewGame
End With
End Sub

 

[shyrath]

Put this in the workbook module

Private Sub Workbook_Open()



newgame.show



End Sub

 

[jammoca]

Thanks for that.

I should have known that one.

If I want the spreadsheet to always open on a particular sheet as well, let's say a sheet called "Menu", how would I do that ?

 

[shyrath]

Try:

Private Sub Workbook_Open()



newgame.show
sheets("menu").select



End Sub