Reply To: Unhide all the hidden sheets in VBA

[Mayank GoyalKeymaster]

Hiding #worksheets in #Excel in one go is easy, you just have to select multiple sheets then right mouse click and then click on hide, but unhiding all the worksheets(that are hidden) in one go is not easy, you have unhide all sheets one by one. So a hashtag#macro that unhides all of the hidden sheets can come in really handy.

 Here’s the code to unhide all the sheets in one go: Open a workbook, select some sheets and hide them and then use this code to unhide your hidden sheets

[img]https://attachment.tapatalk-cdn.com/76772/201908/2171_f40e63832766e823136fc5f6ac081ef9.png?Expires=1568056112&Signature=CuYvB9oVw6vH1xnd69xB6zG~clZbzTvGSznjaMW6ltTaHLMtxjfwA9Mjufe9ymnd6IGgtb1XotTGZ6bJHEVbbh-SjgFNaoNvPuIuSy7q6zWGZbiKWeIB1keHOHLU4lxQLABLr8gr8wjMBbpUbhGi7yDGYkiY~~JQX~8VJA-KJfciR4Uj4VUBcj4TENqC4H72Ep2P-~ExX1kkHZtGt9JkUaL8d5KHMs-qQVh1rFMNAHHW-aewFW2-R1tdUQzWeS-b8UmpRvZhWoziv7mc4ymT6YB5rA~whSZk6NHkIZqm~ERqt5CR1~OHs87QM~mFRfGVDkPuqz997OjGwkmRJXMvpA__&Key-Pair-Id=APKAJS72YROXJYGYDADA[/img]