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

B

bankerguy01

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?
 
I

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
 
D

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
 
Top