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

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.

Workbook_BeforeClose is stored in the ThisWorkbook Module.

--
Regards,
Tom Ogilvy

"davegb" wrote in message
oups.com...
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.

Can you show us the code?

--

HTH

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


wrote in message
oups.com...
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