How can I make certain sheets on a workbook visible or very hidden based on answer (yes or no) entered on cells AM20,AM21,AM22 on sheet 2.
Examples:
If AM20=YES, Sheet 15 is visible, If NO Sheet 15 is very hidden.
IF AM21=YES, Sheet 1, 9, and 10 are visible, If NO sheets 1,9, and 10 are Very hidden.
Thank you.
Examples:
If AM20=YES, Sheet 15 is visible, If NO Sheet 15 is very hidden.
IF AM21=YES, Sheet 1, 9, and 10 are visible, If NO sheets 1,9, and 10 are Very hidden.
Thank you.