View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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