Create a message upon opening of Spreadsheet

[JaneC]

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 Autpen but I'm not sure what it should contain?

Thanks,

Jane

 

[Dave Peterson]

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