Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a message upon opening of Spreadsheet
Hi,
I am wanting to create a reminder message to be displayed when I open a certain spreadsheet. Is there anyway I can do this? I think I can create a maco called Auto_Open but I'm not sure what it should contain? Thanks, Jane |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a message upon opening of Spreadsheet
Option Explicit
sub Auto_open() msgbox "this is where you'd put your message" & vblf & _ "a second line if you want it" end sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm JaneC wrote: Hi, I am wanting to create a reminder message to be displayed when I open a certain spreadsheet. Is there anyway I can do this? I think I can create a maco called Auto_Open but I'm not sure what it should contain? Thanks, Jane -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create an invoice from a spreadsheet | New Users to Excel | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Error message on opening?? | Excel Discussion (Misc queries) | |||
Error message opening Excel97 workbook | Excel Discussion (Misc queries) | |||
How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) |