How do I create a meesage to display when opening Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top