9-If necessary, add the Developer tab to the ribbon. Select cell G1. Create an absolute macro that will clear the
contents of all cells that data is entered into on the BudgetData worksheet by the user. This includes cells G1:G3, B6:D32, F6:F32, and C34. Make sure the macro selects cell G1 after the content is cleared. Name the macro ClearContents and assign the letter C (press and hold SHIFT key) as the shortcut key.
Display the ClearContents macro in the Microsoft Visual Basic for Applications window. Copy the macro code for this macro and close the VBA window. Paste the copied macro code in cell A1 of the Macros worksheet.
Create a relative macro that will apply bold to the font in a row of the report such as A1:G1. Name the macro BoldRow, and then assign the letter B (press and hold SHIFT key) as the shortcut key. Click the Use Relative References button, select the range A1:G1, and complete the macro.
Display the BoldRow macro in the Microsoft Visual Basic for Applications window. Copy the macro code for this macro and close the VBA window. Paste the copied macro code in cell G1 of the Macros worksheet.
10-On the BudgetData worksheet, unlock cells G1:G3, B6:D32, D3, F6:F32 and C34. From the Format Cells dialog box, hide all cells that have formulas: G4, E6:E32, G6:H32.
11- Hide the row and column headers for the BudgetData worksheet. Hide the gridlines for the BudgetData worksheet. Protect the BudgetData worksheet.
Recently Asked Questions
- 1.In an undisturbed sequence of ocean sediment, the youngest sediment is ____. a. at the top of the sequence b. at the bottom of the sequence c. close to the
- 1.The group of organisms with the largest total biomass in the oceans, by far, is the ____. a. microbes b. vertebrates c. invertebrates d. plankton e. fishes
- 4-7 Please and thanks