Microsoft Office Tutorials and References
In Depth Information
Composing a Macro
Type a name for the macro in the Macro name field. A multiword name
must be linked by an underscore (e.g., Company_Logo ), but in the
interests of simplicity, we’ll call our macro Logo . We’ll discuss the
optional Shortcut key and Store macro in fields a bit later, but note here that
you can enter a summary of what the macro does in the Description field
(though this is optional).
Then click OK. Note the small blue
rectangle that appears in the
lowerleft corner of the worksheet, an
indicator that you’ve entered
macrorecording mode; this is the button
you’ll click to stop recording. Hover
your mouse over the button and
you’ll see the message shown in
Figure 11–4. In the studio: The macro recording is in
Then simply click in cell A1 (you should click your mouse in A1 even if
you’re in it already, for technical reasons) and type the logo in cells
A1:A3, as you would normally. I’ve used Arial Black 14-point font here,
but you can choose your own formatting. If you’ve mistyped a word, just
correct it and keep going.
When you’ve completed typing the logo, click that blue macro button.
That stops the recording and saves what you’ve done. The macro is
now available to use.
Save the workbook under the name “Macro lesson.” Here you need to
save the workbook as an Excel Macro-Enabled Workbook, which I’ll