How do I create a meesage to display when opening Excel
 

I am trying to create a message when excel is first opened to remind users
that they should not cut and paste in the document and that they need to
print a worksheet daily.
I would be grateful if anyone could help with this.

How do I create a meesage to display when opening Excel
 

Use Tools | Macro
In the VBA project for the workbook; click on "This Workbook"
Add this subroutine

Private Sub Workbook_Open()
MsgBox "Thou shalt not Cut & Paste" & Chr(10) & "Remember to print daily
report"
End Sub


Need help with VBA: see David McRitchie's site on "getting started" with VBA

http://www.mvps.org/dmcritchie/excel/getstarted.htm

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"kolsk" wrote in message
...
I am trying to create a message when excel is first opened to remind users
that they should not cut and paste in the document and that they need to
print a worksheet daily.
I would be grateful if anyone could help with this.