Pop up Message for each spreadsheet in an excel workbook

[Pkocienda]

I am looking for assistance in how to create a different pop up message when a user opens an individual spreadsheet in a workbook. I am able to create a pop up message when the document opens but need to customize each spreadsheet. Thank you for the assistance.

1 2 3​

Private Sub Workbook_Open() MsgBox "Send this file to xxx" End Sub

 

[JoeMo]

If there's a common thread among the custom messages you may be able to use a Thisworkbook, Workbook_SheetActivate event to produce the messages. Otherwise, you will have to write a Worksheet_Activate event procedure for each sheet.