Excel VBA - Hide sheets based on drop down values in excel cell

This video demonstrates how to hide multiple excel sheets on the basis of the selected value in a drop down list.

#dax #powerbi #except #sqlserver #excel #dataanalysis #dataanalytics #businessintelligence #bi #data #ssas #analysisservices #data #analytics #datascience #dataanalytics #datavisualization #dataanalysis #analyst #data #businessanalytics #bideveloper #bi #analysis #excelfunctions #excelvba #excelformulas #powerquery

[mahboubehamouzgar]

Hi...so thanks for this amazing video🌸🌸🌸 I have lots of sheets and i need to know how can i have several of these sheets with just one option of droplist?

[andrewclarke]

Hi,
the code you posted for keeping certain tabs showing isn't working in the names array, the first code you posted in the video i got to work fine, can you help please?

[daniellemeganmarino]

hi. I have many tabs in my worksheet. If i only want to choose the tabs i want to include in the dropdown list, How will I unhide the tabs that I are not included in the dropdown list?

[HiteshPatel-hqlt]

Hi
Used your Code in my office template. However, minor change is required which I am unable to achieve though.

Can you modify your code a bit.

By default on opening of this file, only sheet "Data" will be visible and rest all other sheets will be hidden, and "Select a sheet" will appear in Range A2.

Now depending upon selection in range A2, i.e. North:South:East:West, only respective Sheet will be unhidden first and made active (Assume North is selected in A2 which should make Sheet "North" be unhidden first and appear along with sheet "Data" and Sheet "North" will be the active Sheet for user to carry out Data entry).

Once Data entry is done in Sheet "North" and when user selects sheet "Data" or Closes the Workbook, Sheet "North" will again get hidden and "Select a Sheet" will appear in range A2 in Sheet "Data" for user to selected another sheet and Cycle of operation continues. So, in other words, after selection in A2 only two Sheets will appear in any case. one "Data" and other selected from range A2.


The Sheet "Data" is locked except for Range A2.
All Data Entry in any sheet selected through Range A2 shall be automatically Saved.

Thanks in advance.

[kingjosepaul]

Hello Antriksh, I created all worksheets, then I inserted a new worksheet for filter and entered hide worksheet VB codes and changed the sheet name as per VB, however its not working ???

[rashmid]

Hi, I am looking for a way to hide / unhide tabs in a protected workbook. is there a way? my excel has multiple private sub codes for multiple sheets.

[angelbhaves]

Hi, I am trying to hide different worksheets based on multiple cell value. Can you help?

[vathsovanna]

If we want to view two sheets at the same time, what is the code?