Hide Multiple Sheets in Excel VBA - ExcelVbaIsFun Quick Tips 

Thanks for the video Dan!

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

Hello, I am trying to hide sheets based on multiple drop-down selections. How would you go about this?

Awesome! Thanks for the video : )

Hi, Dan. It has been a while. It is good to hear from you. I hope you and your family are doing well

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

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

Thanks Dan. Long time since you made a video. Hope all is well.

@angelbhaves1 Did you figure it out? As I have to accomplish the same.

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

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.

Thank you very much for this great video and for this valuable information.

Hi is there any chance to hide in filter

Awesome❤❤❤

Do we have any possibility to hide or veryhide every chosen list? So we can choose multiple lists and hide them at once.

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.