Workbook before close event

Hi

I wish to use the above event and this is the first time I have tried it, however I cannot get it to work no matter what I do. I am sure I am doing something really basic wrong but cannot work it out.

To try it out I cut and pasted the example from VBA help

Please Login or Register  to view this content.

No result when closing, I tried it in 2000, XP and 2007, same result.

I also tried the following

Please Login or Register  to view this content.

Any guidance would be appreciated

Regards


Jeff

Thanks a lot I knew it was going to be something basic, I had the code everywhere BUT there, works fine now.

Thanks again

Regards

Jeff