Excel Close confirmation

[cogdev]

I am trying to implement a documentation standard in the Office. I want to change the default Excel Template to have a 'Notes' Tab. The Notes table will have some standard information to fill in: Name, Date, Project etc.
Is there a way to force a user to fill in this data before closing the spreadsheet?

Thanks

 

[cLFlaVA]

You could put a macro in your Workbook's BeforeClose event. Below is a simplified example.

However, this will not work if the user disables Macros.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    If Sheets("Sheet1").Range("A1").Value = "" Then
        MsgBox "Please Fill in Notes!"
        Cancel = True
    End If
End Sub

*cLFlaVA
----------------------------
Lois: "Peter, you're drunk!"
Peter: "I'm not drunk, I'm just exhausted from stayin' up all night drinking!