Hello all,
I am wondering if I could hide/unhide sheets dynamically based on a cell value. For example, in A1, I will have the following formula.. (If Row B is blank, then "Blank, if not " "). The following sheet macro that I have been working with will hide the sheet if A1=Blank. However, Row B will dynamically be changing as it references other sheets. And once it is hidden, I am having trouble with the macro unhiding once A1 changes to " ".
Thank you in advance and greatly appreciate any guidance.
I am wondering if I could hide/unhide sheets dynamically based on a cell value. For example, in A1, I will have the following formula.. (If Row B is blank, then "Blank, if not " "). The following sheet macro that I have been working with will hide the sheet if A1=Blank. However, Row B will dynamically be changing as it references other sheets. And once it is hidden, I am having trouble with the macro unhiding once A1 changes to " ".
Thank you in advance and greatly appreciate any guidance.
