For some reason, the Workbook_Open event is not firing in one specific
workbook. I created a blank workbook and added the event with a msgbox alert
and it worked fine.
Any ideas why this event wouldn't be firing?
Thanks,
For some reason, the Workbook_Open event is not firing in one specific
workbook. I created a blank workbook and added the event with a msgbox alert
and it worked fine.
Any ideas why this event wouldn't be firing?
Thanks,
It isn't in the thisworkbook module?
--
Regards,
Tom Ogilvy
"0013" <[email protected]> wrote in message
news:[email protected]...
> For some reason, the Workbook_Open event is not firing in one specific
> workbook. I created a blank workbook and added the event with a msgbox
alert
> and it worked fine.
>
> Any ideas why this event wouldn't be firing?
>
> Thanks,
Nope, it's in the correct place.
"Tom Ogilvy" wrote:
> It isn't in the thisworkbook module?
>
> --
> Regards,
> Tom Ogilvy
>
> "0013" <[email protected]> wrote in message
> news:[email protected]...
> > For some reason, the Workbook_Open event is not firing in one specific
> > workbook. I created a blank workbook and added the event with a msgbox
> alert
> > and it worked fine.
> >
> > Any ideas why this event wouldn't be firing?
> >
> > Thanks,
>
>
>
That is the correct place? Tom was suggesting why it didn't work.
--
HTH
Bob Phillips
"0013" <[email protected]> wrote in message
news:[email protected]...
> Nope, it's in the correct place.
>
> "Tom Ogilvy" wrote:
>
> > It isn't in the thisworkbook module?
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "0013" <[email protected]> wrote in message
> > news:[email protected]...
> > > For some reason, the Workbook_Open event is not firing in one specific
> > > workbook. I created a blank workbook and added the event with a
msgbox
> > alert
> > > and it worked fine.
> > >
> > > Any ideas why this event wouldn't be firing?
> > >
> > > Thanks,
> >
> >
> >
Right, I was saying that that wasn't the problem b/c it was in the workbook
module.
"Bob Phillips" wrote:
> That is the correct place? Tom was suggesting why it didn't work.
>
> --
> HTH
>
> Bob Phillips
>
> "0013" <[email protected]> wrote in message
> news:[email protected]...
> > Nope, it's in the correct place.
> >
> > "Tom Ogilvy" wrote:
> >
> > > It isn't in the thisworkbook module?
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "0013" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > For some reason, the Workbook_Open event is not firing in one specific
> > > > workbook. I created a blank workbook and added the event with a
> msgbox
> > > alert
> > > > and it worked fine.
> > > >
> > > > Any ideas why this event wouldn't be firing?
> > > >
> > > > Thanks,
> > >
> > >
> > >
>
>
>
It's somehow working now. I'm not exactly sure why, but I do have a theory.
I'm guessing that piece of code, which temporarily turns off events, threw
an exception and was stoped before it could re-enable events and the document
was then saved and closed. If this was the case, I'm guessing it was fixed
by successfully re-running that code and saving.
"0013" wrote:
> Right, I was saying that that wasn't the problem b/c it was in the workbook
> module.
>
> "Bob Phillips" wrote:
>
> > That is the correct place? Tom was suggesting why it didn't work.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "0013" <[email protected]> wrote in message
> > news:[email protected]...
> > > Nope, it's in the correct place.
> > >
> > > "Tom Ogilvy" wrote:
> > >
> > > > It isn't in the thisworkbook module?
> > > >
> > > > --
> > > > Regards,
> > > > Tom Ogilvy
> > > >
> > > > "0013" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > For some reason, the Workbook_Open event is not firing in one specific
> > > > > workbook. I created a blank workbook and added the event with a
> > msgbox
> > > > alert
> > > > > and it worked fine.
> > > > >
> > > > > Any ideas why this event wouldn't be firing?
> > > > >
> > > > > Thanks,
> > > >
> > > >
> > > >
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks