Microsoft Office Forums - View Single Post - How to Hide/Un-hide a worksheet based on cell on another sheet.

charlesdh · 06-02-2015, 12:07 PM

Hi,

here are 2 simple macros to hide and unhide worksheets.
You need to change the sheet names to that you want to Hide or Unhide name.

Code:

Sub Hide_Worksheet()
If ActiveSheet.Cells(2, 5).Text = "2" Then
    Sheets("Sheet2").Visible = False
End If
End Sub

Code:

Sub UnHide_Worksheet()
If ActiveSheet.Cells(2, 5).Text = "2" Then
    Sheets("Sheet2").Visible = True
End If
End Sub