So I am just starting this project and realized I have no idea what i am doing when it comes to macros and would like some help if you do not mind.
I have the following code I was able to play with but have no idea how to include the code for if it is clicked then show the sheet if not clicked then hide the sheet.
Any type of help would be very helpful please! Thank you in advance for your time and knowledge.
Please Login or Register to view this content.
The problem you will have even if you get it working right is that it will only work an the visible sheet because once it's hidden the button is hidden too.
I would suggest a macro that is placed in the QAT ribbon that will work on the active sheet.
The problem is that when a sheet is not visible you cannot activate it so you will have to work with a list of worksheets present in the file
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I have like 15 sheets on the spreadsheet and the first two would never go away. I just a few others to not be shown until the button is clicked. Then if they unclick the button make it hidden again. I am not worried about if it is not visible there will not be a button on the sheets that are going to be toggled with this button.
You probably misunderstood my answer:
First, always one sheet MUST be visible in Excel.
You cannot address a button on a hidden sheet to undihe it so you will need a picklist to search the hidden worksheet to unhide it.
One the sheet is visible you can (if there is a button on it) click it to hide it.
What is the criteria to unhide a sheet? A username?
Probably something like thisthere will not be a button on the sheets that are going to be toggled with this button
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks