Another "lot of Worksheets" Problem

I would like to tackle another monotonous problem that we often ignore.

The world of finance is essentially the world of spreadsheets. Therefore, it is evident that the application I/we use the most is excel. A few days ago, I was working on a template of credit quality assessment for some issuers. While working I found that almost 50% of the sheets in that template were hidden.

That day I decided that I can't take this anymore. Unhiding all of them one by one is one of the most monotonous problems I have ever faced in my work life. Its hard man, its hard. I have not found any conventional way to resolve this issue. Until now I had chosen to ignore this issue even though it was such a time consuming task. So, this time I have decided to address this issue with a small unconventional solution.

Always remember, if someone say that they have an unconventional solution to an excel related problem, rest assured 99% of the time they will be asking you to use VBA. And I am doing the same. But you don't need prior knowledge of VBA. A simple search on youtube on how to use personal workbook and how to add macro from that to your quick access tool bar or ribbon should do the trick.

Just add below three lines to a new or existing VBA module to the personal workbook.

Sub u_h_s()
For Each ws In Sheets: ws.Visible = True: Next
End Sub

Use this macro by adding it to the ribbon or quick access tool bar.

Voila! You have resolved another problem with three lines.