Excel 2003: No reaction to Workbook_xxx events

[Kimed]

Hi,

I have a workbook that has certain actions programmed for Workbook_Open, Workbook_BeforeClose and Workbook_BeforeSave events. That works okay. But now I copied the whole module into a new workbook where I want similar functionality, but in that one these events don't work. Placing debug MsgBox'es into them shows that they are never called at all, even though the workbook is opened on the same computer and even in the same Excel instance as the old one that still works perfectly. Macro security is set to minimum, macros attached to buttons work OK. What might possibly be the reason?

Thanks.

 

[SkipVought]

Hi,

Since this is a VBA question, it really should be posted in forum707.

I copied the whole module into a new workbook ...[/code]
Workbook & Worksheet events are not in modules that can be copied.

The Workbook events are in the ThisWorkbook Object and cannot be ANYWHERE else.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}