Excel Tutorials

Unhide All Excel Sheets in One Click- VBA

1 minute, 7 seconds Read

In this article, we will see how to unhide all the excel sheets in one click. First, we will hide all the excel sheets and then write a small VBA code to unhide all excel sheets in a single click.

First, hide the sheets that you want to unhide in a single click instead of unhiding one by one.  Hold “CTRL” and select the sheet. After selecting the sheets “Right Click” and then select “Hide”.

Now we will see how to unhide the sheet in a single click via VBA code.

Record macro in Personal workbook and then write code in the personal workbook so that it will be saved in all excel workbook:


  1. Record Macro and name the macro “Unhide_Sheets” or as you want to name that.
  2. Store Macro in “Personal Macro Workbook”.
  3. Click “OK” and stop recording from the left corner status bar.
  4. Launch VBA using “Alt + F11“.
  5. Search for Personal.XLSB. Click on the “+” sign and double click on “Module 1”
  6. Write the following code in Module 1

Under the Sub Procedure as above created macro like ” Sub Unhide_Sheets() ________Code______  End Sub”

Dim Sh as worksheet

For each Sh in worksheets

Sh.visible= True

Next Sh

7. Press “F5” to run this code.

Watch the video below and share your valuable feedback


EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence Pak Vs England: England vs Pakistan FIFA World Cup 2022: CBDT Notifies Income Tax Exemption
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock