I have a large financial model in which I have a "Control Panel" tab that acts as a kind of headquarters in the model, providing navigation links to each tab, error checks, model functionality based on on/off switches, etc.
One of the features I'd like to employ is in the navigation links section next to the tab name I'd like to ideally have a formula that will populate the cell with either "Active" or "Hidden" based on whether that tab is, you guess it, visible or hidden.
Anyone have any idea of how I could do this?
By the way, I don't have any real experience in VBA coding, anything I have done in that regard is very basic so please try to use minimal advanced coding language when trying to help.
Thanks, I appreciate it!
Bookmarks