Hi, is it possible to make sheet very hidden when leaving the sheet?
I have created many sheets, and initially I made them all except sheet1 very hidden, and with some if functions according to entered data in sheet1 I unhide a particular sheet and go there. For instance I have entered some data on sheet 1 and when I run it Sheet2 unhides and opens. What I want is when I click on Sheet1 on tab bar, Sheet2 becomes automatically very hidden. Thanks in advance
I have created many sheets, and initially I made them all except sheet1 very hidden, and with some if functions according to entered data in sheet1 I unhide a particular sheet and go there. For instance I have entered some data on sheet 1 and when I run it Sheet2 unhides and opens. What I want is when I click on Sheet1 on tab bar, Sheet2 becomes automatically very hidden. Thanks in advance