"Workbook_Open" Subroutine Does Not Always Run

[teerman]

I have a workbook that is supposed to call an add-in subroutine via "Workbook_Open" when it is opened. My problem is that the "Workbook_Open" event does not always fire. Has anyone heard of such a bug? What can I do to fix it?

Thanks!
Rick Teerman

[Ivan F Moala]

On 2002-05-21 07:26, teerman wrote:
I have a workbook that is supposed to call an add-in subroutine via "Workbook_Open" when it is opened. My problem is that the "Workbook_Open" event does not always fire. Has anyone heard of such a bug? What can I do to fix it?

Thanks!
Rick Teerman

.

Hi Rick, can't say I have.
Couple of things.
1) How are you opening it ie. Via Code or
manually
2) Are you enabling Macros (Had to ask!)
3) How do you know the event isn't firing ?

[teerman]

Hello Ivan,

Thanks for responding.

1) I open it via the following code:

Private Sub Workbook_Open()
If IsHYDPCAddinInstalled Then
Run ("WorkbookSupport.OpenWorkbook")
Else
MsgBox "This workbook requires the HYDPC Add-In. " & _
"Please install it and try again.", vbOKOnly + vbCritical, _
"HYDPC Add-In Not Installed"
ActiveWorkbook.Close (False)
End If
End Sub

2) Yes (of course!)

3) WorkbookSupport.OpenWorkbook does not run and the MsgBox does not display

Rick Teerman

[Ivan F Moala]

On 2002-05-21 07:55, teerman wrote:
Hello Ivan,

Thanks for responding.

1) I open it via the following code:

Private Sub Workbook_Open()
If IsHYDPCAddinInstalled Then
Run ("WorkbookSupport.OpenWorkbook")
Else
MsgBox "This workbook requires the HYDPC Add-In. " & _
"Please install it and try again.", vbOKOnly + vbCritical, _
"HYDPC Add-In Not Installed"
ActiveWorkbook.Close (False)
End If
End Sub

2) Yes (of course!)

3) WorkbookSupport.OpenWorkbook does not run and the MsgBox does not display

Rick Teerman

1)If I understand you correctly then you are
opening via code?
2) What version ? Xl97 ?


What version

[teerman]

1) yes, via code

2) Excel 97