How are you opening the file?

If you have a macro in one workbook that opens this second workbook and that
macro is started by a shortcut key, remove the shift from that shortcut key
combination.



Ozzy wrote:

I do Dave. I can get this functionality to work in any other workbook, but
just not this one !

Thanks, Ozzy

"Dave Peterson" wrote:

You do have those procedures in the ThisWorkbook module, right?

Ozzy wrote:

Good idea Norman, tried it but to no effect. The code is not the problem, I
have replaced it with a simple message box pop-up but it still does not
work.. The code works fine when it is run directly after the workbook is open.

Cheers, Ozzy

"Norman Jones" wrote:

Hi Ozzy,

Perhaps Events have been turned off.

Goto the VBE (Alt-F11)
Select the Immediate window (Ctrl-G)
Type: Application.EnableEvents = True
Hit Enter
Try re-loading the problematic file.

If the problem subsists, post your code.

---
Regards,
Norman



"Ozzy" wrote in message
...
I cannot get my Workbook_Open() or Workbook_BeforeClose() macros to run
when
the workbook is opened. The macros work fine in any other workbooks, just
not this one ... Any ideas?

Using XL 2003




--

Dave Peterson


--

Dave Peterson