I have a sheet containing this code and some other stuff too. But this section of code causes the macro to run slow. Is there any way to speed this up and make it run faster? Basically when a user enters something into one of the cells it will show the sheet associated with that cell. Hopefully there is a better way.
Private Sub Worksheet_Change(ByVal Target As Range)
Set rng = ActiveCell
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
If Range("AB193") <> "" Then
Worksheets("Issue 1").Visible = xlSheetVisible
Else
Worksheets("Issue 1").Visible = xlSheetHidden
End If
If Range("AB194") <> "" Then
Worksheets("Issue 2").Visible = xlSheetVisible
Else
Worksheets("Issue 2").Visible = xlSheetHidden
End If
If Range("AB195") <> "" Then
Worksheets("Issue 3").Visible = xlSheetVisible
Else
Worksheets("Issue 3").Visible = xlSheetHidden
End If
If Range("AB196") <> "" Then
Worksheets("Issue 4").Visible = xlSheetVisible
Else
Worksheets("Issue 4").Visible = xlSheetHidden
End If
If Range("AB197") <> "" Then
Worksheets("Issue 5").Visible = xlSheetVisible
Else
Worksheets("Issue 5").Visible = xlSheetHidden
End If
If Range("AB198") <> "" Then
Worksheets("Issue 6").Visible = xlSheetVisible
Else
Worksheets("Issue 6").Visible = xlSheetHidden
End If
If Range("AB199") <> "" Then
Worksheets("Issue 7").Visible = xlSheetVisible
Else
Worksheets("Issue 7").Visible = xlSheetHidden
End If
If Range("AB200") <> "" Then
Worksheets("Issue 8").Visible = xlSheetVisible
Else
Worksheets("Issue 8").Visible = xlSheetHidden
End If
If Range("AB201") <> "" Then
Worksheets("Issue 9").Visible = xlSheetVisible
Else
Worksheets("Issue 9").Visible = xlSheetHidden
End If
If Range("AB202") <> "" Then
Worksheets("Issue 10").Visible = xlSheetVisible
Else
Worksheets("Issue 10").Visible = xlSheetHidden
End If
If Range("AB203") <> "" Then
Worksheets("Issue 11").Visible = xlSheetVisible
Else
Worksheets("Issue 11").Visible = xlSheetHidden
End If
If Range("AB204") <> "" Then
Worksheets("Issue 12").Visible = xlSheetVisible
Else
Worksheets("Issue 12").Visible = xlSheetHidden
End If
If Range("AB205") <> "" Then
Worksheets("Issue 13").Visible = xlSheetVisible
Else
Worksheets("Issue 13").Visible = xlSheetHidden
End If
If Range("AB206") <> "" Then
Worksheets("Issue 14").Visible = xlSheetVisible
Else
Worksheets("Issue 14").Visible = xlSheetHidden
End If
If Range("AB207") <> "" Then
Worksheets("Issue 15").Visible = xlSheetVisible
Else
Worksheets("Issue 15").Visible = xlSheetHidden
End If
If Range("AB208") <> "" Then
Worksheets("Issue 16").Visible = xlSheetVisible
Else
Worksheets("Issue 16").Visible = xlSheetHidden
End If
If Range("AB209") <> "" Then
Worksheets("Issue 17").Visible = xlSheetVisible
Else
Worksheets("Issue 17").Visible = xlSheetHidden
End If
If Range("AB210") <> "" Then
Worksheets("Issue 18").Visible = xlSheetVisible
Else
Worksheets("Issue 18").Visible = xlSheetHidden
End If
If Range("AB211") <> "" Then
Worksheets("Issue 19").Visible = xlSheetVisible
Else
Worksheets("Issue 19").Visible = xlSheetHidden
End If
If Range("AB212") <> "" Then
Worksheets("Issue 20").Visible = xlSheetVisible
Else
Worksheets("Issue 20").Visible = xlSheetHidden
End If
If Range("AB213") <> "" Then
Worksheets("Issue 21").Visible = xlSheetVisible
Else
Worksheets("Issue 21").Visible = xlSheetHidden
End If
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Bookmarks