BeforeClose Macro

[thefoolmccool]

Hi,

Have a workbook saved in excel 2002 with the following macro:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call Macro1
End Sub

And macro1 is another macro required to run befor e I close the book. But unfortunately, this doesnt run when I prees either the X at the top right hand corner or >File>Close

Any ideas? (I am not much of a VBA wizard!!!)

[davesexcel]

when does it run? if it doesn't run on either of the actions, you might not have the code in the right spot
here's is a site the explains where the workbook module is

http://www.contextures.com/xlvba01.html

[JR@SGC]

Have you got the sub workbook before close in the 'This Workbook' module? Rather than a standard module. Macro 1 however should be in a standard module.

There is nothing wrong with the following code

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call Macro1
End Sub


Unless there is something in macro1 itself causing this?

Hope it helps

[thefoolmccool]

Thanks guys you were both right, I had not placed the code in the "This Workbook" section. I was unaware that this had to be done, at least I will know in future

Thanks for a very quick response!

Kev