User function and Open Event
Are you saying that the open workbook event is not working or that your
function is not working?
What does your 'startmodel' procedure do, maybe this is where the problem
lies?
Cheers
Nigel
"Yuriy" wrote in message
...
I have this code:
Private Sub Workbook_Open()
startmodel
End Sub
In Excel 97 this do not working! In 2003 this works perfect... After
debugging I find strange thing... Into workbook I use user function
for dividing...:
Function div0(a, b) As Double
Dim result As Double
If b = 0 Then
result = 0
Else
result = a / b
End If
div0 = result
End Function
If I set " Manual Calc" all is OK (after loading workbook "starmodel"
executes perfekt)?! But if calculating is automatic when book loads
"startmodel" not starting? How to resolve this problem into Excel97
without setting Manual Calculating?
TIA
|