If you turn off events, then workbook_open won't fire.
application.enableevents = false
workbooks.open filename:="C:\zzzz.xls"
application.enableevents = true
If you hold down the control key (or the shift key) when you're opening the
workbook, auto_open and workbook_open won't fire.
If you are opening a workbook via a macro and you used a shortcut key for that
macro that included the shift key, then excel gets confused and will not fire
the workbook_open or auto_open.
(I'm still guessing that the workbook was already open when you clicked on the
entry under the File dropdown.)
Bill Martin wrote:
Changing the code doesn't count. I did a Copy/Paste to put the code here so
that I'd know it was precisely what was in the VBA. I also allowed VBE to
insert the code itself from a menu once rather than me typing it in. I got the
same code and the same problem. Not an error statement of any kind -- it just
doesn't execute.
I'm sort of presuming (hoping?) that somewhere is a security feature of Excel
that allows you to turn off the automatic Workbook_Open event, and which I've
inadvertently set or some such.
Incidentally, can you tell me what version of Excel you tested it with?
Thanks...
Bill
-------------------------
Norman Jones wrote:
Hi Bill,
You code worked for me 'as is'.
If, however, I introduced a minor spelling error, I could replicate your
experience, e.g.:
Private Sub Workbbook_Open()
MsgBox "Workbook_Open Called"
Call AddButtons
End Sub
---
Regards,
Norman
"Bill Martin" wrote in message
...
I'm using Excel97 and have trouble with Workbook_Open().
Within the module "ThisWorkbook" I have the following three event handler
calls:
Option Explicit
Private Sub Workbook_Activate()
Call AddButtons
End Sub
Private Sub Workbook_Deactivate()
Call DeleteButtons
End Sub
Private Sub Workbook_Open()
MsgBox "Workbook_Open Called"
Call AddButtons
End Sub
The Activate and Deactivate events work properly. If I have multiple
workbooks open, whenever this particular workbook is selected from the
Window menu, the code is called and executes as one would expect.
The Workbook_Open event never seems to get called. I open Excel, and then
from the File menu open this workbook, but the code never gets called.
Originally it did not have the MsgBox statement, but I added that for
debug and it never gets called either.
Am I doing something wrong? Is this a known bug in Excel97? It seems
like I've reduced the problem to such a simple example that it *must*
work, but it doesn't.
Thanks...
Bill
--
Dave Peterson
|