Can I hide all worksheet tabs and when worksheet is selected from listbox that sheet tab is visible?
Can I hide all worksheet tabs and when worksheet is selected from listbox that sheet tab is visible?
Last edited by zplugger; 03-27-2015 at 10:20 PM.
When opening workbook close all sheets (I've put also example if you don't want to hide some sheet):
And then when click on listbox just unhide it:Please Login or Register to view this content.
Please Login or Register to view this content.
First part works Great, can not get it to go to sheet when selected from listbox1
Setting should be dependant on listbox
but would need example to work with it.Please Login or Register to view this content.
Here it is, if you have time.One problem I'm having is my sort will not work with hidden sheets.
Got this far, but when another list item is selected it should hide current sheet and unhide new item.
Please Login or Register to view this content.
Didn't yet see your file but based on your code try to create macro from above:
Then call it when opening sheet:Please Login or Register to view this content.
But also each time you run macro:Please Login or Register to view this content.
Please Login or Register to view this content.
File in #5
Code does unhide sheet but leaves it unhidden when another sheet is selected.
Last edited by zplugger; 03-27-2015 at 04:34 PM.
Here, I've copy above codes for you.
Since (at least) one sheet must always be visible I've use Sheet1 for that.
I See, I was putting Sub Hide Sheets in wrong,Thank you for showing me. Is there a way around sorting the sheets now or will I just
unhide all before sort. Not sure what is best way.
Please Login or Register to view this content.
You need to sort them only once right?
Since after that they will always be sorted.
You can do that too on workbook open
Thanks for all your help zbor, tried the sort code in workbook open before hiding sheets with no luck.Just added a button to
userform to unhide and sort.
Try replace Worksheet open with this:
If you want to sort them each time then you can put upper part of the code within Hide_sheets macro.Please Login or Register to view this content.
Thanks for the Code work zbor, what a nice surprise. Again Thank You for helping.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks