course bg
EduPristine>Blog>More Hide and Seek with Financial Modeling!

More Hide and Seek with Financial Modeling!

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:

#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

#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!

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 41796