AwesomeSteph
Board Regular
- Joined
- Aug 18, 2017
- Messages
- 80
I have a workbook with 16 sheets.
If [H18:H44] in sheet3 has an "I" or a "VOS" ((these are from a data validation drop down menu and are the users only options) bigger problem there is a "V" option as well not sure if that is going to make it impossible since VOS has a V in it.) I want sheet13 to be visible, if that range is either blank or including a "V" I want sheet13 to be hidden. What I have does not work (it has worked on other spreadsheets I have created so I am lost). Please help.
this is the sheet3 microsoft excel object.
If [H18:H44] in sheet3 has an "I" or a "VOS" ((these are from a data validation drop down menu and are the users only options) bigger problem there is a "V" option as well not sure if that is going to make it impossible since VOS has a V in it.) I want sheet13 to be visible, if that range is either blank or including a "V" I want sheet13 to be hidden. What I have does not work (it has worked on other spreadsheets I have created so I am lost). Please help.
this is the sheet3 microsoft excel object.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If [H18:H44].Value = "I" Or [H18:H44].Value = "VOS" Then
Sheets(13).Visible = True
Else
Sheets(13).Visible = False
End If
End If
Application.ScreenUpdating = True
End Sub