December 5, 2013
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:
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.
This will create a module in the VBA:
Now, we need to write the following code in the window on the right side:
It will show in the window as following, after this press the run button:
I hope you enjoyed going through this post! Please feel free to post your comments, queries or doubts below!