Workbook Open/BeforeClose Problem
Hi Dave,
Just a simple file open, not called from another macro
"Dave Peterson" wrote:
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
|