Pop up screen when tab is selected

[starbwoy]

Anyone know how to get a pop up screen to appear when a tab is selected. One of those screens that have message and the user has to press okay to use the tab.

Thanks

[MickG]

Hi, if you put this in a "Workbook activate" Event. The Message Box will appear in every sheet you open, and tell you what the sheet name is.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
MsgBox "You Have selected Sheet (" & ActiveSheet.Name & ")"
End Sub

Regards Mick

[starbwoy]

I only need the pop up screen in one sheet tell the user how to use the sheet.

Is that possible?

Thanks,

[Simon Lloyd]

Just put it in the worksheet module you want to use (ALt+F11 then double click the sheet you want to work with and paste:

Private Sub Worksheet_Activate()
MsgBox "You Have selected Sheet (" & ActiveSheet.Name & ")"

End Sub