Workbook_BeforeClose event does not execute

[Liz_I3]

Hi
My Workbook_BeforeClose event does not execute

I wanted my workbook to calculated before it closes

I put in the message box just to see if it would display. It does not

and it does not call calcbook

I have it on ThisWorkbook

I am working with excel 2007, is there and option I need to activate?

Thanks
L

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.EnableEvents = True

Sheets("Data").Select
ActiveSheet.Calculate
Application.Calculation = xlAutomatic
Application.CalculateBeforeSave = True

Call CalcBook

MsgBox ("HELLO")


End Sub

 

[wigi]

What is the value of Application.EnableEvents when you are bound to close the file? Does the event itself fire?

 

[Liz_I3]

No, I had turned them off earlier, so I was putting them back on. But you are correct they don't have to be there. But I don't even think the code executes to that point. When I close the workbook it immediatley asks if you want to save the changes. Then closes

L

 

[wigi]

But I don't even think the code executes to that point.

A simple MsgBox or Debug.Print right after "Private Sub Workbook_BeforeClose(Cancel As Boolean)" will give you that information.

Where do put the code?

Please use code tags when you post code to the Board, thanks.

 

[Liz_I3]

I put it on ThisWorkbook

L

 

[wigi]

Did you do the MsgBox or Debug.Print?

 

[RoryA]

If you turned the events off earlier, did you turn them back on? If not, the event won't work.

 

[Liz_I3]

Thanks Rorya That was exactly the problem

L

 

[wigi]

Thanks Rorya That was exactly the problem

L

Hmmm, but you wrote earlier that you turned them on again?

No, I had turned them off earlier, so I was putting them back on. But you are correct they don't have to be there. But I don't even think the code executes to that point. When I close the workbook it immediatley asks if you want to save the changes. Then closes

L

 

[RoryA]

Yes, but turning them on in the BeforeClose event, which wasn't firing because events were off.