Issues with code to prevent saving changes on close

[davidam]

Hello All,
Long ago, I copied the following code into the Workbook Objects.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveWorkbook.Saved = True
Cancel = True
End Sub

It has always worked fine, it seems. However, I sometimes have some kind of memory leak that occurs when I close other workbooks while this workbook is open. I wonder if anyone can comment
on the variables that are bracketed in the above code, which seem to have no purpose that I can find.
Thanks,
David

 

[davidam]

Memory leakage seems to be much better

 

[Joe4]

When marking a post as the solution, please mark the post that actually contains the solution.