HSV
Inventaris
- Lid geworden
- 18 jul 2008
- Berichten
- 20.329
- Office versie
- Office 365
Test het zo maar eens weer.
Code:
Dim check As Boolean
Private Sub worksheet_calculate()
If check = False Then
If IsError(Evaluate("'" & Range("b3") & "-" & Range("E3") & "'!a1")) Then
check = True
ActiveSheet.Name = Range("B3") & "-" & Range("E3")
Exit Sub
Else
check = True
MsgBox "Bladnaam al aanwezig"
Exit Sub
End If
End If
check = False
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If check = False Then worksheet_calculate
End Sub