Possible to have a formula to show "TRUE"/"FALSE" depending on sheet visibility?

[povictory]

Hello!

Is there a way to have an output in a cell show "True" or "False" depending on if another tab is visible or not visible? I'm looking to leverage that output for some other formulas/conditional formatting, but I only want to do that if another specific tab is visible and available to the user.

Any assistance is greatly appreciated!

 

[bebo021999]

There's another macro that unhides it when a hyperlink to the tab is clicked from another sheet. Apologies, but could you share how adding the additional line would look in the code?

Could you share that macro?

 

[povictory]

Could you share that macro?

Sure! It is below:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Dim desk As String
Dim shtname As String
Dim desk2 As String

  shtname = Left(Target.SubAddress, InStr(1, Target.SubAddress, "!") - 1)
  desk = Right(shtname, Len(shtname) - 1)
  desk2 = Left(desk, Len(desk) - 1)
  Sheets(desk2).Visible = True
  Sheets(desk2).Select

End Sub

 

[bebo021999]

Assume output was in cell A1, sheet "Main"

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Dim desk As String
Dim shtname As String
Dim desk2 As String

  shtname = Left(Target.SubAddress, InStr(1, Target.SubAddress, "!") - 1)
  desk = Right(shtname, Len(shtname) - 1)
  desk2 = Left(desk, Len(desk) - 1)
  Sheets(desk2).Visible = True
' new added part: paste "desk2" visible statistic in to other sheet "Main"
  Sheets("Main").range("A1").value = "True"
'---------------
  Sheets(desk2).Select
End Sub