Rudi
r.gomez <r.g...@iaea.org> schreef in artikel
<DD8C7CE3FFD94B4283A804C7D7B61FB629AF4A@CPMSFTMSGV22>...
'check for Excel version, turn on Assistant if Excel 2k
Dim oAssist As Object, Ass As Integer
If Val(Application.Version) >= 9 Then
Set oAssist = Assistant
If oAssist.On = True Then
Ass = 1
Else
oAssist.On = True
Ass = 2
End If
End If
this code restores the worksheet to it's original assistant situation.
If Val(Application.Version) >= 9 Then
If Ass = 2 Then oAssist.On = False
End If
r.gomez <r.g...@iaea.org> wrote in message
news:DD8C7CE3FFD94B4283A804C7D7B61FB629AF4A@CPMSFTMSGV22...
On my computer:
In Excel 97 the function returns: "Excel version 8.0e, build 5618".
In Excel 2000 the return value is "Excel version 9.0, build 2719"