Hi,
I am tryinh to figuree out how to write a macro that will hide a given worksheet that is not in use.
Scenario: Financial model for electricity generation for multiple locations. Main control sheet allows to select via pulldown menu if that given location should be included in combined financial results. (I got that covered). However, I would like that the worksheet for that location as it is not in use to be hidden automatically.
Thanks for your thoughts
I am tryinh to figuree out how to write a macro that will hide a given worksheet that is not in use.
Scenario: Financial model for electricity generation for multiple locations. Main control sheet allows to select via pulldown menu if that given location should be included in combined financial results. (I got that covered). However, I would like that the worksheet for that location as it is not in use to be hidden automatically.
Thanks for your thoughts