Hiding/Showing a sheet with a variable name based on cell value

[Jack3010]

Hi,

I have a workbook where the sheets change name depending on cells values in a master sheet but if there are no cell values i want the sheets to hide. Just wondering if anyone could help as im new to VBA

Thanks
Jack

 

[mugginsjr]

You might have a look at Automatically Rename Worksheet Based On Cell Value From Another Sheet

Here is a snippet I made that you can put in your master sheet module. If you put the word Change in A1 and C5, and then click on them, you should see Sheet1's name change

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" And UCase(Target) = "CHANGE" Then
    Sheet1.Name = "Josephine"
End If
If Target.Address = "$C$5" And UCase(Target) = "CHANGE" Then
    Sheet1.Name = "Sheet1"
End If
End Sub

 

[mugginsjr]

This is how you would hide a sheet based on A1 being empty

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Value = "" Then
    Sheet1.Visible = False
    Else
    Sheet1.Visible = True
End If
End Sub