View Single Post
 
Old 06-02-2015, 12:07 PM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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
Reply With Quote