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


"Patrick Molloy" wrote in message
...
try

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

Patrick Molloy
Microsoft Excel MVP

"J_J" wrote:

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.

--------
Private Sub Workbook_BeforeClose()
ActiveWorkbook.Save
End Sub
--------

Regards
J_J