Using the spreadsheet for Homework #7, create a macro (with a button to activate it) that will hide any of the Operating Expense categories (Salaries & Wages through Other Expenses, lines 9 16) if none of the months for a category includes an expense amount. Also, create a macro button and macro that will unhide all of the categories so that following months can be filled in as they occur.

Requirements: 1. You should have 2 to 3 accounts to have a Total of 0 (see column N), so that you can hide these accounts (that is, no expenses incurred in any of the 12 months for these few accounts). However, it is important to remind you that your VBA code should be flexible enough to hide any account that has a sum of 0 balance---meaning that if I change an non-zero account in your table to 0, and click Hide button, your code should be able to hide this account too (similarly, if I replace zero-sum account in your table with nonzero values, and click the Hide button, this account should not be hidden any more)

2. For those remaining accounts which do have a nonzero Total, you dont have to input values for each of 12 months. You may leave most of the months blank. All you need to do is make up some numbers for some months so that the Total for that account is nonzero.

In this case, create a macro button that would hide rows 12,13, 15.

Dy formuffy Tell me View e Share Comments AutoSaveFF ADES : Home Insert Draw Page Layout Arial 11 Paste BI V B G18 x fx | Formulas A A Data = Review = = 2), B V General Conditional Formatting insert v Delete Eu 494 O 3 Conditional Formatting 12 Format as Table Coll styles v A YE $ Ideas % Sort & Filter Format Find & Select Sensitivity X HLUK M N O P Q R S 1 DEPARTMENTAL PERFORMANCE January February March Apri July 201.5 89 116 4 Revenues 5 Cost of Goods Sold 6 Gross Profit 287 May 144.5 116 28.5 June 173 136 37 August 230 176 54 September October 250.5 196 216 November December Total 315,5 344 2247 236 256 1752 79.5 495 156 20 45.5 62.5 71 100 122 67 111 78 69.5 132 100 82.5 144 111 166 133 56 56.5 155 122 95.5 1266 870 63 76 89 102 795 8 Operating Expenses: 9 Salarios & Wages 10 Repairs & Maintenance 11 Bad Debts 12 Rents 13 Taxes and Licenses 14 Depreciation 15 Advertising 16 Other Expenses 17 Total Expenses 18 19 Operating Profit 23 GB 77 86 104 870 0 0 63.7 361.7 0 79.1 0 113 0 102.2 587.7 122 0 109.9 632. 9 56 86.8 71.4 406.9 810.6 4611.6 168 146 279 94.5 542.5 316.5 452.1 4973 - 150 -168 -200 -259 -288 -324.7 -361.4 398.1 434.9 471.5 -508.2 -544.9 4116.6 21 Your Score: /100 28 29 30 31 32 35 36 37 18 39 Sheet1 + One or more add-ins failed to install custom functions. e u - + 100% Dy formuffy Tell me View e Share Comments AutoSaveFF ADES : Home Insert Draw Page Layout Arial 11 Paste BI V B G18 x fx | Formulas A A Data = Review = = 2), B V General Conditional Formatting insert v Delete Eu 494 O 3 Conditional Formatting 12 Format as Table Coll styles v A YE $ Ideas % Sort & Filter Format Find & Select Sensitivity X HLUK M N O P Q R S 1 DEPARTMENTAL PERFORMANCE January February March Apri July 201.5 89 116 4 Revenues 5 Cost of Goods Sold 6 Gross Profit 287 May 144.5 116 28.5 June 173 136 37 August 230 176 54 September October 250.5 196 216 November December Total 315,5 344 2247 236 256 1752 79.5 495 156 20 45.5 62.5 71 100 122 67 111 78 69.5 132 100 82.5 144 111 166 133 56 56.5 155 122 95.5 1266 870 63 76 89 102 795 8 Operating Expenses: 9 Salarios & Wages 10 Repairs & Maintenance 11 Bad Debts 12 Rents 13 Taxes and Licenses 14 Depreciation 15 Advertising 16 Other Expenses 17 Total Expenses 18 19 Operating Profit 23 GB 77 86 104 870 0 0 63.7 361.7 0 79.1 0 113 0 102.2 587.7 122 0 109.9 632. 9 56 86.8 71.4 406.9 810.6 4611.6 168 146 279 94.5 542.5 316.5 452.1 4973 - 150 -168 -200 -259 -288 -324.7 -361.4 398.1 434.9 471.5 -508.2 -544.9 4116.6 21 Your Score: /100 28 29 30 31 32 35 36 37 18 39 Sheet1 + One or more add-ins failed to install custom functions. e u - + 100%