VBA To show and hide selection pane

[Undo]

Hello

Looking for VBA code that show selection pane if its closed
and close it if its showing
Thanks

[karedog]

Maybe :

Please Login or Register  to view this content.

Run it to toggle, on .. off .. on .. off .. on .. off .. .. .. ..

[Andy Pope]

You can use this to toggle selection pane state

Please Login or Register  to view this content.

you can use this to determine state

Please Login or Register  to view this content.

[Undo]

While I am tring with vba code
the pane now is not showing
even when I click it from find
even also in new file

[karedog]

Maybe the pane position is out of screen, try to run this code :

Please Login or Register  to view this content.

If you click manually by hand, and even trying it on new file, and the pane is not shown, the culprit is not the VBA, but must be something else (e.g. the position of pane, interfere from third party addon, etc).

[rick.duncan]

Very nice. Thank you. Big help.
The extra test was essential. W/o current state I could not switch as desired. Each worksheet now sets up the way I want.