Try thiis,
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Response As Long
Dim isect As Range
On Error GoTo ExitLine
With Application
.ScreenUpdating = False
.EnableEvents = False
End With
Set isect = Intersect(Target, Range("H11"))
If Not isect Is Nothing Then
Select Case Target
Case ""
UnhideOpen
Case "Annual PM or TSC", "Product Clinical Demo"
UnhideTSC
Case "Clinical Support", "Emergency Service", "Upgrade or Update"
Response = MsgBox("Will a TSC be performed during this service visit?", vbYesNo + vbQuestion, "Perform TSC?")
If Response = vbYes Then
UnhideTSC
Else
UnhideRoutine
End If
Case "Conference or Commercial Demo", "Decommission"
UnhideDemo
End Select
End If
ExitLine:
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
On Error GoTo 0
End Sub
Cheers
Sorry for rush on time limited machine
Bookmarks