The open event works fine. The module starts working, and it stops at the
first instance where I reference the form. I can see that because when it
stops I go into DEBUG mode to see where the module has problems and it is on
the reference to the form.

The error I get is of type "File not found".




"Tom Ogilvy" wrote:

It was a question - I left off the ? <g

Is the workbook_open event in the thisworkbook module? It must be.

Is the symptom that the userform doesn't show when you open the workbook
(indicating that the workbook_open event is not firing) or that you get an
error about an undefined object or something like that (indicating the code
ran and the userform was not found)?

--
Regards,
Tom Ogilvy

"DKS" wrote in message
...
I open only one workbook, the workbook that contains the problematic form.
The WORKBOOK_OPEN event fails; but when I go into the VBA editor via .xls
I
see the form.

Thus I believe it cannot be the explanation that you gave?

"Tom Ogilvy" wrote:

the userform isn't in the same workbook as the workbook with the
workbook_Open event.

--
Regards,
Tom Ogilvy


"DKS" wrote:

Hi,

What could be the possible reasons for a workbook_open event not
finding a
user form?

I am running into this situation and just cannot seem to figure out the
reason for such a behaviour.

All help is appreciated.