Workbook_BeforeClose doesn't work!!!

[wooda]

Hi I am using Excel 2002 SP3, so every workbook opens in the same excel
window. And I am trying to use workbook_beforeClose method to execute
some action. And as the action in workbook_beforeClose method executes
when I close the whole excel window, It does NOT work when i close only
current workbook!!!
what may be the problem???
regards
wooda

 

[davegb]

Is the macro stored in the sheet, or in a module? I believe that for
that to work, it has to be stored in the sheet. At least it did in 2000.

 

[Bob Phillips]

Can you show us the code?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Workbook_BeforeClose is stored in the ThisWorkbook Module.