Macro of the day: Hide Unhide sheet manager - Free

[vabs]

Hi Excel champs,

Today i want o share with you a powerful macro for those who are dealing with lots of sheets in single book & wish to hide unhide sheet very frequently..

This macro has module wherein on loading this you will get 2 listboxes, listbox1 will show all visible sheets & listbox2 will show all hidden sheets..

If you want to hide any sheets from those visible ones, juts select sheet name one by one from left listbox & click on 1st button (>) in center..

If you want to unhide any sheets from those hidden ones, juts select sheet name one by one from right listbox & click on 2nd button (<) in center..

On contrary if you want to hide all visible sheets then click 3rd button (>>>) in center & if you want to unhide all hidden sheets then click 4th button (<<<).

And if you have loads of sheet then above all list box there is one textbox to filter sheets, just type name of sheet & data will get filtered & select sheet name & push it to opposite side.

Please note you can not hide all sheet so i have kept sheet named "Main" out of reach of code which will be by default visible..

Also you can double click on name of item appearing listbox to move that on opposite side & after that click button Hide / Unhide to give impact..

You can also use shortcut key Ctr + Shft + W to load Sheet Manager macro.

Let me know if you liked it or not.

[Ashish Kumar]

​Dear Vaibhav Sir,

It's Superb. 

Great Work.

@ All Group Members,

Please check this. Really useful and share your comments on the same.

Regards

Ashish Kumar​

[Ashu K]

Dear Vaibhav Sir,

I didn't see this kind of macro in my life. It's really amazing. 

Thanks for sharing with us. Thumbs Up and 10 Stars to you.

Regards

Ashu Kenith

[Eugene Bernard]

Fantastic Idea and codes.

Thanks Vaibhav,  for sharing.

Reagrds
Eugene

[Ashish Bhalara]

Thanks vaibhavji to sharing so intelligent coding and tool which help to working with so many sheet very easily.

Your logic power and your innovative mind make you a genius. Ones again thanks to share your innovation and your human being nature to be very helpful to all group members.

--
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/c91652f4-87b5-4a55-b51a-e0fa4f424c63%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Regards.

Ashish Bhalara

9624111822

PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣

[Vaibhav Joshi]

Thanks Ashish & Ashu..

On Sun, Jun 14, 2015 at 8:41 PM, Ashu K <direct...@gmail.com> wrote:

--

You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.

[Vaibhav Joshi]

Cheers!!

--
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/d96fc35f-8a33-41a5-9215-8f14494643e8%40googlegroups.com.

[Bob Phillips]

I would suggest two things for this tool:

- first, remove that message after moving anything, it is annoying and you can easily see from looking at the lists that it has happened.

- add it to the sheets context menu, so you right-click any of the sheets tab and you see an additional menu option to launch the form

[Vaibhav Joshi]

Good Suggestion Bob...will accommodate this in next version..

Cheers!!

--
www.ExcelVbaLab.com
---

You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/d21bbc6a-0163-432d-85eb-b1b6848d9770%40googlegroups.com.

[Yasser Khalil]

Really awesome .. Thanks for sharing that masterpiece

[Pravin Gunjal]

Hi Vabz

Its so nice creativity. 

Thanks

Pravin Gunjal

On Sunday, June 14, 2015 at 3:29:04 PM UTC+5:30, vabs wrote:

[finuxl82]

nice , thanks