View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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.