Show hidden wrksht(s) by clicking a button on an always visible wrksht, in same wrkbk
I have four hidden worksheets with data. I have one visible worksheet with four buttons that will show each "data sheet" respectively. How can I have only the "active" sheet tab displayed along with my visible worksheet tab when I click the desired button?
Hi Jakeh,
Welcome to the forum.
Which one is the "active" sheet tab here?
Is it any one among four hidden worksheets and you want to have only one open (with button click) ?
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Yes, the always visible worksheet tab contains the buttons that show the hidden worksheet tabs.
My purpose is to have the hidden tabs' visibility controlled only by .cmd buttons.
Thanks,
Jake
Hello jakeh2475,
I think the attached WorkBook, will put you on track!
Please consider:
Be polite. Thank those who have helped you. Click the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks