Lauren

You could put some code in the Workbook_Open() event that would fire each
time the workbook is opened

Private Sub Workbook_Open()
MsgBox "You must do this!"
End Sub


You could put the closing code in the Workbook_BeforeClose() event like so

Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Have you done this?"
End Sub

These sit in the ThisWorkbook module. This can be accessed by right
clicking the small Excel icon next to the file menu and selecting 'View
code'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"laurenm" wrote in message
...
Hi all,

Is there anyway I can create a pop up message that would remind the user
to
do something upon opening an Excel sheet and on closing the Excel sheet?
This
sheet is something our users are editing but it would be nice to have them
automatically reminded to perform a specific action. We are using Excel
2002
and Excel 2003. I know there are message alerts I can create but I think
they
only apply if someone fills in certain data in a cell.

Any help would be greatly appreciated.

Thanks!
LaurenM