C
Cathy
Is there a way of prompting the user with a message when
he or she clicks on a certain sheet tab?
Thank you
he or she clicks on a certain sheet tab?
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Michl
You would do this in VBA by attaching some code to the sheet object. Since
you posted in the Functions newsgroup not programming, I'll assume you don't
know how to program in VBA. Here's a step by step.
1) Start in the workbook that should include the message. (Doesn't need to
be the worksheet, just the book.
2) Press Alt-F11 to open the VBA editing window.
3) Look for the project window which shows a tree diagram with an entry
called Microsoft Excel Objects. Expand it if you don't see the sheets below
it.
4) Click on the sheet that should have the message. (In my example, Sheet1.
5) Copy the code below in the white work area to the right of the tree
diagram.
Private Sub Worksheet_Activate()
MsgBox ("You just clicked on Sheet1")
End Sub
6) Alt-tab back to the Excel sheet, select a different sheet and then
reselect Sheet1. The message box should pop-up.
- John Michl
www.JohnMichl.com
you posted in the Functions newsgroup not programming, I'll assume you don't
know how to program in VBA. Here's a step by step.
1) Start in the workbook that should include the message. (Doesn't need to
be the worksheet, just the book.
2) Press Alt-F11 to open the VBA editing window.
3) Look for the project window which shows a tree diagram with an entry
called Microsoft Excel Objects. Expand it if you don't see the sheets below
it.
4) Click on the sheet that should have the message. (In my example, Sheet1.
5) Copy the code below in the white work area to the right of the tree
diagram.
Private Sub Worksheet_Activate()
MsgBox ("You just clicked on Sheet1")
End Sub
6) Alt-tab back to the Excel sheet, select a different sheet and then
reselect Sheet1. The message box should pop-up.
- John Michl
www.JohnMichl.com
C
Cathy
-----Original Message-----
You would do this in VBA by attaching some code to the sheet object. Since
you posted in the Functions newsgroup not programming, I'll assume you don't
know how to program in VBA. Here's a step by step.
1) Start in the workbook that should include the message. (Doesn't need to
be the worksheet, just the book.
2) Press Alt-F11 to open the VBA editing window.
3) Look for the project window which shows a tree diagram with an entry
called Microsoft Excel Objects. Expand it if you don't see the sheets below
it.
4) Click on the sheet that should have the message. (In my example, Sheet1.
5) Copy the code below in the white work area to the right of the tree
diagram.
Private Sub Worksheet_Activate()
MsgBox ("You just clicked on Sheet1")
End Sub
6) Alt-tab back to the Excel sheet, select a different sheet and then
reselect Sheet1. The message box should pop-up.
- John Michl
www.JohnMichl.com
.
Thank you sooooo much John - You're the bomb!