Hello,
I have an Excel book with various sheets. On the main page the user should be able to Unhide a sheet based on a select option. I don't have any Vba coding skills, is there a source where I can copy and paste the code?
Thanks
Hello,
I have an Excel book with various sheets. On the main page the user should be able to Unhide a sheet based on a select option. I don't have any Vba coding skills, is there a source where I can copy and paste the code?
Thanks
Of course it is easy doable but help us to help You.
Please attached small simple file. Describe exactly how You imagine it to work.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
If your sheet names are in the range B3:B5 (change this as needed), when you double click the name of the sheet, it will unhide it, hide all other sheets, and then activate the sheet for you. To add this code, right click the sheet that will have the contents and choose View Code. Paste this in there:
Please Login or Register to view this content.
Thanks thomglea for the reply.
Unfortunately the code does not work for me. The code seems to be based on Cells, I am looking to unhide the sheet based on the name of: Sheet 1 User selects "Overview", Overview sheet unhides, remaining sheets remain hidden.
Cheers
Maybe read Post #2 again.
Experience trumps academics every day of the week and twice on Sunday.
"unhiding by entering" a name:
Paste this code into the standard module.Please Login or Register to view this content.
Last edited by mjr veverka; 03-30-2024 at 07:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks