The other day I was in here asking for a way to display the last save date automatically. I used the following method, as described in one of the responses:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveSheet.PageSetup.CenterFooter = Now()
End Sub
Now I am getting an error message when I close Excel (not individual workbooks, just the program itself).
Complie error in hidden module: modDJScommandbars.
And when I open Excel:
Compile error in hidden module: modAppOpenClose
Any thoughts on what this might be or how to fix it? I'm running Excel 97 on a Windows NT 4.0 machine.
Thanks