I copied a macro from this forum to provide a "slideshow" effect rotating between tabs via setting the Conditional formula to vShow =1, vShow2, etc on each tab in Show Sheet. This works fine.
I now have a requirement to be able to "freeze " a tab.
What I would like to do is to provide a button (Stop SlideShow ) that would execute a macro to set the Show Sheet property from Conditional to Always and another button (Resume ) to revert back to Conditional, but cannot find any reference to that property so far.
Is my solution possible ? If so, could you provide either a reference for me to look at or the macro to set the property.