| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WORKBOOK_OPEN event
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
WORKBOOK_OPEN event
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
WORKBOOK_OPEN event
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
WORKBOOK_OPEN event
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
WORKBOOK_OPEN event
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
WORKBOOK_OPEN event
try exporting the useform. Delete it. Save the workbook. Close Excel. Open
Excel, open the workbook, Import the userform. Make sure there is a reference to the MSForms 2.0 library. (in the VBE, tools=References) -- Regards, Tom Ogilvy "DKS" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook_Open() Event | Excel Discussion (Misc queries) | |||
| Workbook_open Event | Excel Programming | |||
| Workbook_Open Event | Excel Programming | |||
| WorkBook_Open Event | Excel Programming | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Hybrid Mode
