How do you determine programmatically the name of the active sheet/panel?
I have two panels and would like to know in code which panel is selected. I cannot believe I am not able to figure this out!!
As you can see in this example there are two sheets called ‘Consolidated’ and ‘Detail’.
How can I determine which one is selected? Keep in mind that some other controls might have the focus and not necessarily the tab itself.
If you can determine which control has the focus/isactive
then I wonder if you could work backwards via parent(s) until you hit the panel that contains that control?
e.g. the thread below included a solution related to parents… looked interesting (to me):
The post you linked was mine - I do it by keeping track of which tab is active, I don’t believe I was able to find a way to reliably get the active name otherwise.