I have a cell in excel that is either true or false. Based on that then it is linked to a check box. When ever I type the word "True" it marks the check box, but does not unhide the tab unless I physically click on the box.
I would like it if the box is checked based on the text linked to it checks it, to unhide the tab labeled "Affidavit". Here is the macro code I have assigned to the check box:
Dim s As String, cbx As CheckBox
s = Application.Caller
Set cbx = ActiveSheet.CheckBoxes(s)
If cbx.Value = xlOn Then
Worksheets("Affidavit").Visible = xlSheetVisible
Worksheets("Affidavit").Visible = xlSheetHidden