Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Need to know the meaning of error meesage | Excel Discussion (Misc queries) | |||
How can I display a message when opening an Excel File? | Excel Discussion (Misc queries) | |||
how do i create a dialog box to appear on opening an excel wkbook | Excel Discussion (Misc queries) | |||
Display a message when opening Excel file | Setting up and Configuration of Excel | |||
How can I make Excel display a message (dialog box) upon opening a spreadsheet? | Excel Discussion (Misc queries) |