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!
Our counsellors will get in touch with you with more information about this topic.
* Mandatory Field