msgbox function

[cliodne]

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

 

[Ardus Petus]

In your sheet's code:

Private Sub Worksheet_Activate()
MsgBox "Warning"
End Sub

HTH
--
AP

"cliodne" <[email protected]> a écrit
dans le message de
news:[email protected]...

 

[cliodne]

Brilliant!!

Thank yo