Hi All,
I have no background nor proper training on handling VBA/Macros but sooner I would like to learn at least the basic of it. I am thinking to create a template that would help me navigating on my report efficiently, can anyone could please help me create a simple macro that control (hid/unhide) tabs on my excel – then probably I can use it to pattern on others.
Ideas:
Control Tab – this contains shapes which I would like to assign a macro when clicked. They are Week 1, 2, 3, 4, Hide All, Dashboard, Report and Tally.
The idea is to show ONLY the tabs that I would like to see on my workbook.
Expected Outcomes:
1. When I clicked WEEK 1, it will only show tabs W1-1, W1-2, W1-3, W1-4 and W1-5
2. When I clicked WEEK 2, it will only show tabs W2-1, W2-2, W2-3, W2-4 and W2-5
3. When I clicked WEEK 3, it will only show tabs W3-1, W3-2, W3-3, W3-4 and W3-5
4. When I clicked WEEK 4, it will only show tabs W4-1, W4-2, W4-3, W4-4 and W4-5
5. When I clicked HIDE ALL, it will hide all tabs EXCEPT the CONTROL tab
6. When I clicked DASHBOARD, it will only show the DASHBOARD and the CONTROL tabs
7. When I clicked REPORT, it will only show the REPORT and the CONTROL tabs
8. When I clicked TALLY, it will only show the TALLY and the CONTROL tabs
By the way, I am using excel 2016
Kindly see the sample workbook I’ve attached for your reference.
Thank you all in advance…I would take it as a first step to a more complicated VBA functions.
Appreciate your help.
Dy
Bookmarks