Hi,

Is there any way that I can make a message appear when I open the file? Eg.
I want a reminder to come up when the file is opened to say €œRemember to Log
all changes to Fleet List in Checklist€�.

Can anyone help??

Thanks, Jane.

One way:

Use an event macro. If you're unfamiliar with macros, see David
McRitchie's "Getting started with Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Put this in the ThisWorkbook code module:

Private Sub Workbook_Open()
MsgBox "Remember to Log all changes to Fleet List" & _
" in Checklist"
End Sub


In article ,
"JaneC" wrote:

Is there any way that I can make a message appear when I open the file? Eg.
I want a reminder to come up when the file is opened to say €œRemember to Log
all changes to Fleet List in Checklist€�.