Help needed with this autosave macro problem

[J_J]

Hi,

My whole intention is to close the active workbook without beeing prompth by
Windows "do you wanna save the changes....". But unfortunately when I use
the below code I am getting a Compile error with the msgbox
"Procedure declaration does not match description or event procedure having
the same name".
Hope someone can help me to correct this.

 

[Guest]

try

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub

Patrick Molloy
Microsoft Excel MVP

 

[J_J]

Ahaa!....
So the trick was to have "cancel as boolean"
Thanks Patrick.
That did it!.
J_J

try

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub

Patrick Molloy
Microsoft Excel MVP

 

[Dave Peterson]

Sometimes, it's better to be lazy.

If you used those dropdowns at the top of the code window in the VBE, then
you'll get the correct name/syntax for those builtin events.

Ahaa!....
So the trick was to have "cancel as boolean"
Thanks Patrick.
That did it!.
J_J