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, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), 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. Then Click on 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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks