Hi

Better use the beforeclose event so the user can cancel the close

Copy this in the thisworkbook module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim ans As Long
ans = MsgBox("Do you fill in your working hours?", vbOKCancel)
If ans = vbOK Then
'do nothing
ElseIf ans = vbCancel Then
Cancel = True
End If
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"toontje" wrote in message l...
I am looking for a macro that opens a msgbox when exit the workbook to remind you
like "you fill in your working hours?"

is that Private Sub AutoClose() ?

and where do i put it?