Hide and Unhide Worksheets

[ExcelNel101]

Good day!

Im new here and would really need your help. I would like to hide and unhide my worksheets using the control button. Using home or sheet 1 I'll be placing the title of the other sheets. If the title/control button is clicked the sheet will open, but when I clicked home, it will go back to sheet 1. Hope you guys will help me... Thank you in advance.

Nel

[MarvinP]

He Nel and welcome to the forum.

Here is some VBA code that does this and an example file so you can see how it works.

Please Login or Register  to view this content.

[Kaper]

Hi Nel and welcome to the forum.
Invest some time to familiarize with our http://www.excelforum.com/forum-rule...rum-rules.html - you will find there not only typical "do and do not" but also tips how to got help effectively.

You can find also some similar threads on the forum (use search) like: http://www.excelforum.com/excel-prog...heets-vba.html or http://www.excelforum.com/excel-prog...orksheets.html for instance.

[ExcelNel101]

Thank you so much! I'm currently checking the codes. Looking forward to learn more. Thank you MarvinP!

[ExcelNel101]

Thank you Kaper! We'll get myself familiarized with the forum rules! Again, thank you

[Sam Capricci]

If you are interested in trying it without VBA you can use custom views under view. When the sheet is open and you see it the way you want it, say all the sheets are visible, you go to the view tab and open custom views then add and name the view what you want like show all (or whatever you want). Then hide the sheets you want hidden, repeat the view >> custom views >> add >> and name what you want like final view and save. After that every time you open that workbook you can go to view and open custom view, select one of those and hit ok and the book will show the views you want. You can set many views you might want like final view, show all or working view etc and once it is set up it is just two clicks away.