A client is using an Excel file that we created that contains some VBA code. He enables macros when it opens and everything works fine. However, when he tries to close the file, it asks for a VBAProject password. The only Workbook_BeforeClose event is shown below.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub
Saving has been disabled in the workbook and this just tells the workbook to close without asking about saving even if it has been modified.
We have tested this same file in two different versions of Excel and we don't get the message when we close it. Does anyone have an idea of what might cause this?
Thanks,
Dave
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub
Saving has been disabled in the workbook and this just tells the workbook to close without asking about saving even if it has been modified.
We have tested this same file in two different versions of Excel and we don't get the message when we close it. Does anyone have an idea of what might cause this?
Thanks,
Dave