Yep, instead of using "Private Sub Workbook_BeforeClose(Cancel As Boolean)" you should use "Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)"
Yep, instead of using "Private Sub Workbook_BeforeClose(Cancel As Boolean)" you should use "Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks