Problem

Automating Repetitive Tasks.  Once a week you have to develop a new worksheet for your dep...

Automating Repetitive Tasks.  Once a week you have to develop a new worksheet for your department head that inserts enrollment data.  More specifically most of the tasks that you perform in creating the worksheet are very repetitive since the structure of the worksheet is always the same.  You want to automate the steps that are repetitious.  Using the Macro Recorder, create a macro that types six month names as three letter abbreviations, “Jan” to “Jun,” across the top of a worksheet, starting in cell B1.  Make each abbreviate bold, italics, and centered within each cell.  Call the macro MonthNames and assign the macro the shortcut key Ctrl+Shift+M.  Save the workbook as MonthNames.xls.  Open a new worksheet, and press Ctrl+Shift+M.

Step-by-Step Solution

Request Professional Solution

Request solution!

We need 3 more requests to produce this problem solution. Share with your friends to get the problem solution faster!

0 /3 have requested this problem solution

Request! (Login Required) Share with friends


Once 3 people have made a request, the problem solutions will be available in 1-2 days.
All students who have requested the problem solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search
Solutions For Problems in Chapter M