Hello,
I'm pretty experienced with Excel and have been using it extensively for almost 2 decades now. However, my knowledge of VBA and Macros is very limited. I am looking for someone to help me with a few macros that will trigger when specific cells change to specific values withing a pretty complex spreadsheet I have been working on for a couple years now. I have it almost finished but have been completely stumped by how to get past this hurtle.
At this point I really don't want to start learning how to create VBAs and was just hoping I could send someone my spreadsheet along with instructions on what I would like it to do.
Is there anyone out there willing to help me with this? I will list what I would like to have done below and if anyone is interested in helping I can send you the spreadsheet I would like it done to. Thanks,
Here is what I want to do:
If ‘Score Sheet’ cell $AI$2=1
Hide:
‘Score Sheet’ Tab: Only Rows 211 thru 813
‘Leaderboard’ Tab: Only Rows 211 thru 429
‘Flighting’ Tab: Only Rows 11 thru 13
16 thru 18
21 thru 23
26 thru 28
31 thru 33
36 thru 38
41 thru 43
46 thru 48
51 thru 53
56 thru 58
61 thru 63
66 thru 68
71 thru 73
76 thru 78
81 thru 83
86 thru 88
91 thru 93
96 thru 98
101 thru 103
106 thru 108
If ‘Score Sheet’ cell $AI$2=2
Hide:
‘Score Sheet’ Tab: Only Rows 10 thru 210
411 thru 813
‘Leaderboard’ Tab: Only Rows 10 thru 201
303 thru 429
‘Flighting’ Tab: Only Rows 12 thru 13
17 thru 18
22 thru 23
27 thru 28
32 thru 33
37 thru 38
42 thru 43
47 thru 48
52 thru 53
57 thru 58
62 thru 63
67 thru 68
72 thru 73
77 thru 78
82 thru 83
87 thru 88
92 thru 93
97 thru 98
102 thru 103
107 thru 108
If ‘Score Sheet’ cell $AI$2=3
Hide:
‘Score Sheet’ Tab: Only Rows 10 thru 411
613 thru 813
‘Leaderboard’ Tab: Only Rows 10 thru 302
371 thru 429
‘Flighting’ Tab: Only Rows 13
18
23
28
33
38
43
48
53
58
63
68
73
78
83
88
93
98
103
108
If ‘Score Sheet’ cell $AI$2=4
Hide:
‘Score Sheet’ Tab: Only Rows 10 thru 613
‘Leaderboard’ Tab: Only Rows 10 thru 370
If ‘Score Sheet’ cell $AJ$3=9
Protect:
‘Score Sheet’ Tab: Columns M thru U
Hide:
‘Leaderboard’ Tab: Columns M thru W (in addition to all cells previously hidden by other macros).
I'm pretty experienced with Excel and have been using it extensively for almost 2 decades now. However, my knowledge of VBA and Macros is very limited. I am looking for someone to help me with a few macros that will trigger when specific cells change to specific values withing a pretty complex spreadsheet I have been working on for a couple years now. I have it almost finished but have been completely stumped by how to get past this hurtle.
At this point I really don't want to start learning how to create VBAs and was just hoping I could send someone my spreadsheet along with instructions on what I would like it to do.
Is there anyone out there willing to help me with this? I will list what I would like to have done below and if anyone is interested in helping I can send you the spreadsheet I would like it done to. Thanks,
Here is what I want to do:
If ‘Score Sheet’ cell $AI$2=1
Hide:
‘Score Sheet’ Tab: Only Rows 211 thru 813
‘Leaderboard’ Tab: Only Rows 211 thru 429
‘Flighting’ Tab: Only Rows 11 thru 13
16 thru 18
21 thru 23
26 thru 28
31 thru 33
36 thru 38
41 thru 43
46 thru 48
51 thru 53
56 thru 58
61 thru 63
66 thru 68
71 thru 73
76 thru 78
81 thru 83
86 thru 88
91 thru 93
96 thru 98
101 thru 103
106 thru 108
If ‘Score Sheet’ cell $AI$2=2
Hide:
‘Score Sheet’ Tab: Only Rows 10 thru 210
411 thru 813
‘Leaderboard’ Tab: Only Rows 10 thru 201
303 thru 429
‘Flighting’ Tab: Only Rows 12 thru 13
17 thru 18
22 thru 23
27 thru 28
32 thru 33
37 thru 38
42 thru 43
47 thru 48
52 thru 53
57 thru 58
62 thru 63
67 thru 68
72 thru 73
77 thru 78
82 thru 83
87 thru 88
92 thru 93
97 thru 98
102 thru 103
107 thru 108
If ‘Score Sheet’ cell $AI$2=3
Hide:
‘Score Sheet’ Tab: Only Rows 10 thru 411
613 thru 813
‘Leaderboard’ Tab: Only Rows 10 thru 302
371 thru 429
‘Flighting’ Tab: Only Rows 13
18
23
28
33
38
43
48
53
58
63
68
73
78
83
88
93
98
103
108
If ‘Score Sheet’ cell $AI$2=4
Hide:
‘Score Sheet’ Tab: Only Rows 10 thru 613
‘Leaderboard’ Tab: Only Rows 10 thru 370
If ‘Score Sheet’ cell $AJ$3=9
Protect:
‘Score Sheet’ Tab: Columns M thru U
Hide:
‘Leaderboard’ Tab: Columns M thru W (in addition to all cells previously hidden by other macros).
Last edited by a moderator:
