I'm not sure if what I'm trying to do is possible, but I have a workbook
where if a sheet is selected, I need a msgbox to pop up under certain
circumstances. I'm not having a problem with the circumstance part,
but with the msgbox popping up. I thought that if I put the following
code in "thisworksheet" or in the sheet under the excel objects, then
it would work automatically (much like when a user form appears when a
workbook is opened), but no such luck.

If Sheets("Summary").Select Then
MsgBox ("Please make sure that the currency choice and percentage
of attendance are uniform for all sheets before viewing this page.
Thank you.")
End if

Any help is greatly apprciated. Thanks,
Cami


--
cliodne
------------------------------------------------------------------------
cliodne's Profile: http://www.excelforum.com/member.php...o&userid=28774
View this thread: http://www.excelforum.com/showthread...hreadid=533247

In your sheet's code:

Private Sub Worksheet_Activate()
MsgBox "Warning"
End Sub

HTH
--
AP

"cliodne" a écrit
dans le message de
...

I'm not sure if what I'm trying to do is possible, but I have a workbook
where if a sheet is selected, I need a msgbox to pop up under certain
circumstances. I'm not having a problem with the circumstance part,
but with the msgbox popping up. I thought that if I put the following
code in "thisworksheet" or in the sheet under the excel objects, then
it would work automatically (much like when a user form appears when a
workbook is opened), but no such luck.

If Sheets("Summary").Select Then
MsgBox ("Please make sure that the currency choice and percentage
of attendance are uniform for all sheets before viewing this page.
Thank you.")
End if

Any help is greatly apprciated. Thanks,
Cami


--
cliodne
------------------------------------------------------------------------
cliodne's Profile:
http://www.excelforum.com/member.php...o&userid=28774
View this thread: http://www.excelforum.com/showthread...hreadid=533247

Brilliant!!

Thank yo

--
cliodn
-----------------------------------------------------------------------
cliodne's Profile: http://www.excelforum.com/member.php...fo&userid=2877
View this thread: http://www.excelforum.com/showthread.php?threadid=53324