View the step-by-step solution to:

Question

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

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes