Rather than use a custom view, Episode 789 shows how to create a 3-line macro to unhide all worksheets.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Well, in yesterday's netcast, we talked about how frustrating it is when you have many worksheets to unhide.
You might have to choose FORMAT, SHEET, UNHIDE, and, unfortunately, you can't select all of them at once.
You have to select each one individually and then click OK.
So, yesterday, I used a CUSTOM VIEW to solve this.
Today, I'm just going to write a macro and this is usually what I do.
I'll do INSERT, MODULE, create a new macro called SUB UNHIDEALL, and we'll say, FOR EACH SH -- that's just the variable -- IN ACTIVEWORKBOOK.WORKSHEETS, SH.VISIBLE=TRUE, NEXT SH sends it back to get the next worksheet.
Basically, this is just going to unhide all the worksheets in the book.
So, you see we have 3 sheets visible here.
When I run the macro, ALT+F8, choose UNHIDEALL, click RUN, it very quickly unhides all the sheets -- so, tiny little macro, basically 3 lines of code there.
You can put that in your personal macro workbook, and maybe assign it to either an icon or a shortcut key, and you'll have 1-click access to unhide all the sheets.
Well, there you have it.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
Well, in yesterday's netcast, we talked about how frustrating it is when you have many worksheets to unhide.
You might have to choose FORMAT, SHEET, UNHIDE, and, unfortunately, you can't select all of them at once.
You have to select each one individually and then click OK.
So, yesterday, I used a CUSTOM VIEW to solve this.
Today, I'm just going to write a macro and this is usually what I do.
I'll do INSERT, MODULE, create a new macro called SUB UNHIDEALL, and we'll say, FOR EACH SH -- that's just the variable -- IN ACTIVEWORKBOOK.WORKSHEETS, SH.VISIBLE=TRUE, NEXT SH sends it back to get the next worksheet.
Basically, this is just going to unhide all the worksheets in the book.
So, you see we have 3 sheets visible here.
When I run the macro, ALT+F8, choose UNHIDEALL, click RUN, it very quickly unhides all the sheets -- so, tiny little macro, basically 3 lines of code there.
You can put that in your personal macro workbook, and maybe assign it to either an icon or a shortcut key, and you'll have 1-click access to unhide all the sheets.
Well, there you have it.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
