This blog is an extension of our blog on Let’s Play Hide and Seek with Financial Modeling and Excel!

I hope you enjoyed reading the first blog of this series. We will continue with how to ‘Unhide’ sheets in this blog.

Un-hiding multiple sheets is a tough task in Excel. First way to solve this problem is to use the “Custom Views” feature. This feature behaves like memory storage; you specify that you want to directly view a particular number of worksheets and you can see it.

We start keeping in mind that we need to unhide all worksheets and follow the steps mentioned below:

#Financial Modeling Using Excel

#Financial Modeling Using Excel

This is a tough task in case you have a huge file, and it has multiple sheets hidden. You want to study this excel workbook and for that you need to unhide all the worksheets.

#Financial Modeling Using Excel

#Financial Modeling Using Excel

#Financial Modeling Using Excel

#Financial Modeling Using Excel

#Financial Modeling Using Excel

#Financial Modeling Using Excel

This will create a module in the VBA:

#Financial Modeling Using Excel

 

Now, we need to write the following code in the window on the right side:

#Financial Modeling Using Excel

It will show in the window as following, after this press the run button:

#Financial Modeling Using Excel

#Financial Modeling Using Excel

I hope you enjoyed going through this post! Please feel free to post your comments, queries or doubts below!