I'm looking for code that will hide one or more worksheets based on a cell value in Sheet1. For example if cell A2 (in Sheet1) = 2, then hide Sheet5 and Sheet6; again if A2 = 3, then hide Sheet6.
I'm a newbie and have been trying for the code for last few days but failed. So I'm looking for help from experts here.
Thanks in advance.