I have included the worksheet change code as well. So anytime, the worksheet [some] is hidden, the button [btn-1] is hidden. So if worksheet [some] is unhidden, then we can see button [btn_1] visible.
I have a code that’s working but I want it to be very good and never break – because it’s very very important to hide the button when sheet some is hidden – any suggestions or improvements is greatly appreciated. And I want to make sure I am doing that the right way.
Sub Worksheet_Change(ByVal target As Range)
'if worksheet [some] is visible, only then show button [btn_1]
If (Sheet2.Visible = xlSheetVisible) Then
).Visible = True
).Visible = False