Pop-up Message for each worksheet in a workbook

P

patsy

I have a workbook with 3 worksheets in it. The worksheets are named -
Meat-Page 1, Meat-Page 2, Cheese. When the workbook is opened an automatic
pop-up message box appears. The workbook is always opened to the first tab
(Meat-Page 1). Is there a way that if the user changes to Tab 2 (Meat-Page
2) the pop-up message appears again by just switching tabs? I want to make
this workbook idiot proof which I am finding out is not easy. Thanks for the
help.
 
G

Gary''s Student

In the worksheet code area of each sheet, include the following event macro:

Private Sub Worksheet_Activate()
MsgBox ("This is your complementary message:" & Chr(10) & "You look great
today!")
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary worksheet within a workbook 5
Printing Sheets in a Workbook 3
Excel 2007 crashes on copying worksheet to new workbook 0
How to save each tab as a new workbook 6
Print worksheet 2 on back of worksheet 1, etc.... 1
Only one worksheet in a workbook is available for viewing. 7
Switching between sheets in same workbook (Like Alt + Tab & Choose 4
Pop up message on Worksheet 3

Top