How can I display a message for users on file open?

[Guest]

I am interested in creating a default instructional reminder for all users of
a spreadsheet I have created. How can I do this and have the reminder
displayed each time the file is opened?

 

[Ian Digby]

1. With the workbook open, press Alt-F11.
2. From the menu, choose View, then Project Explorer.
3. Open the section called "ThisWorkbook"
4. Type the follwing:
Sub MyMessage

end Sub

 

[Dave Peterson]

I think Ian meant to type this for #4:

sub workbook_open()
Msgbox "don't forget to" & vblf & _
"pick up your laundry on Friday!"
end sub