Hi

Rightclick the sheet tab, choose "view code", paste this in

Private Sub Worksheet_Activate()
MsgBox "How dare you, o deadly one !", _
vbOKOnly + vbCritical, "Kneel !"
End Sub

Alter the text to fit you needs.

HTH. Best wishes Harald

"jdawg" skrev i melding
oups.com...
I just have a quick question. I have a tab called MASTER and I want to
have a message box pop up whenever someone clicks on this MASTER tab
warning them "Changing these two dates, changes all dates in the
headers of the Excel Worksheet." I believe there is a message box that
shows a circle with an X in it and I think you use +vbCritical, but I'm
not positive. Any help would be greatly appreciated.