Hide Multiple Sheets in Excel VBA - ExcelVbaIsFun Quick Tips
HTML-код
- Опубликовано: 6 сен 2024
- 📊 Free Workbooks: www.excelvbais...
🥷Join Excel Ninja Pro: www.excelvbais... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbais... (Free downloads, Trainings, Live Q&A and more)
Learn how to hide multiple excel worksheets using a quick VBA snippet. Super easy!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbais... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbais...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbais...
Hi Dan
Thanks for the video I am a little lost in the VBA formulas and I think I have a much more complicated scenario.
So I have a main sheet and about 6 sheets (Tabs) I need to hide all at the same time if nothing is selected in my drop-down menu. When I choose an item from the menu I only want the sheet referenced in the drop-down menu to appear. This is true for each of the drop-down menus. lets make it easier, I have 2 drop down menu and each menu should only reference 5 sheets per drop-down menu.
drop-down menu 1 - references 5 sheets (Sheet 2, 3, 4, 5, 6)
- Pens, erasers, paper, toner, rulers
drop-down menu 2 - references 5 sheets (Sheet 7, 8, 9, 10, 11)
- Coffee, Tee, Soda, Hot Chocolate, milk
So to explain if I select Pens from my drop-down on my main sheet all the other sheets must stay hidden except for the sheet named Pens.
And like wise for the 2nd drop-down, when I select Soda then all the sheets should stay hidden except for Soda.
However I want to now be able to see only 3 sheets, the main sheet, the Pens sheet and the Soda sheet and all other sheets should still remain hidden....
Question how do I achieve this in VBA. I have been looking at all kinds of suggestions today and I can make it hide all the sheets, and display one sheet however when I select another sheet it a) either does not hide the fist sheet and displays the send selected sheet or the formula returns an error.
Are you able to assist or guide me to a place on the when where I can get more info on VBA please.
I can also send you the actual workbook if you wanted to take a look at what I am trying to achieve.
Hello, I am trying to hide sheets based on multiple drop-down selections. How would you go about this?
Hi! I have an question: it is possible for users to use the file simultaneously and to display each the visible sheets for their own user?
Hey Dan, any chance you have a video or can direct me to a video that shows how to make use of information in other excel files in excel vba to create a new file? I can do this by opening and closing them in a macro but I had heard there's a way that works without opening and closing workbooks
Hi, Dan. It has been a while. It is good to hear from you. I hope you and your family are doing well
Hi Scott! Great to hear from you as well! I apologize for the 'sabbatical', but I'm glad to be back. Thanks!
Thank you very much Nice Video . very help full Video .👍❤
Sir Kindly Help one more video
how to Print Selected Multipal Hide Sheets in VBA Butten Please Help me Theanks
Thanks Dan. Long time since you made a video. Hope all is well.
Thanks, Kevin! All is well, busy as ever, but glad to make some more videos if they will help the excel community! :) Hope you are super well also!
Hi is there any chance to hide in filter
Hey Dan thanks for the video very interesting, Im new to VBA what Im looking for is a way to hide unhide folders based on a letter or word on a seperate sheet its for a calendar if I right jan in cell a1 a January or and feb for a february worksheet now hiding January and all other workbooks? Thanks
Do we have any possibility to hide or veryhide every chosen list? So we can choose multiple lists and hide them at once.
Hi Zrbite0,
I would make different macros that hide what you need as in this video, this way you can call whichever macro to do these things for you. Hope that makes sense. Thanks
Dan
Thank you very much for this great video and for this valuable information.
Thanks for the video Dan!
Awesome❤❤❤
Thanks!!
Awesome! Thanks for the video : )
ExcelIsFun, you are super duper awesome! Thanks, sir!!!
@ExcelVbaIsFun Can you please show how to hide show selected sheet in drop down list, and hiding non selected tabs.
hi...
i have tried to hide hyperlink sheets in vba. i have used this programming,
dim shtName as string
'shtName = Target .Name
shtName = left(Target .SubAddress, Instr (1, Target .SubAddress, "!" ) -1)
Sheets (shtName) .Visible = xlSheetVisible
Sheets (shtName) .Select
but it is not working. it shows select some macros enabled files for this. please guide how to do this.
Hi there, not sure what you mean by 'it shows select some macros enabled files for this'. Can you elaborate please? Thanks
@@ExcelVbaIsFun excel shows a popup when i am trying to save vba code. It is
Can’t save without any enabled macros. Or save as normal workbook.
This is the popup shows
@@zain1991 Ok, I see. You need to save the file as a macro enabled file, so ending in .XLSM or .XLSB instead of normal .XLSX file. If this popup occurs, just tell it to cancel the save and do a File->Save As
@@ExcelVbaIsFun tried but didn’t work.. i have sent you an email kindly check and inform me where is the fault.
hi...
i have tried to hide hyperlink sheets in vba. i have used this programming,
dim shtName as string
'shtName = Target .Name
shtName = left(Target .SubAddress, Instr (1, Target .SubAddress, "!" ) -1)
Sheets (shtName) .Visible = xlSheetVisible
Sheets (shtName) .Select
Hi Dr Zain,
What do you mean hyperlink sheets? Does your code have errors or is it working as you wanted?
thanks
Dan
@@ExcelVbaIsFun i made buttons and hyperlinks other sheets with buttons on a single sheet in same workbook…. I am trying to hide linked sheets with vba. So after hide sheets my hyperlinks works properly…. But my code is not working. When i hit save in vba screen… pop up and error that without an macro enabled sheet can not save codes. And save as normal workbook…. Code i have shared already
@@ExcelVbaIsFun can i get your email plz so i can share you screenshot for more clear and easy for you to understand.
@@zain1991 Sure, let's use admin@excelvbaisfun.com
Thanks
Dan
@@ExcelVbaIsFun ok thank you
@angelbhaves1 Did you figure it out? As I have to accomplish the same.