How to run a Macro?
/////////////////////////
Method I: 
---------
  Step 1: Click "Developer"
  Step 2: Click "Macros"
  Step 3: choose a macro 
  Step 4: Click "Run"

Method II: 
----------
   If a macro is linked with a key such as a, 
      then hit Ctrl-a to run related macro
      see 27(3) for an example

Method III: 
-----------
   Click a linked button see c27(13) on how to 
      generate such a button
    >c27(13)

/////////////////////////

How to edit a macro? 
/////////////////////////

 Step 1: Click "Developer"

 Step 2: Click "Macros"

 Step 3: choose a macro 

 Step 4: Click "Edit"

/////////////////////////

The simplest Macro
/////////////////////////

 Step 1: Click "Developer"
 Step 2: click "Macros"
 Step 3: enter a name 
         [assume that you enter test]
 Step 4: click  "Creat"
 Step 5: [you will see, the following three lines
          the second line is a blank line]

         Sub test()

         End Sub

 Step 6: [replace the 2nd blank line with the following one]

         Range("B10").Value = "No"
  
 Step 7: close 

 Meaning of the macro?
 Enter No for Cell B10
/////////////////////////

When recording, short cut: Ctrl-a
/////////////////////////
 Step 1: Click "Developer"

 Step 2: click "Record Macros"

 Step 3: enter a name 
         Shortcut key:
                Ctrl + [a]

 Step 4: [your action here]

 Step 5: Click "Stop Recording"

 Now,  you can use Ctrl-a to run your recorded macro. 

/////////////////////////

Assign a short-cut key 
/////////////////////////
Assume that you have a macro already and you want to 
 assign a shortcut key to it. 

 Step 1: Alt-F8
         [Alternatively]  "Developer" -> "Macros"

 Step 2: [ choose your macro ]

 Step 3: Click "Options..."

 Step 4: Assign a key

/////////////////////////

Message box: Hello World!
/////////////////////////
 Step 1: Click "Developer"
 Step 2: Click "Macros"
 Step 3: enter a name, such as "hello"
 Step 4: Click "Create"
         You will see the following 3 lines:
         Note the 2nd line is a black line. 

   Sub hello()

   End Sub

 Step 5: [Replace the 2nd blank line with the following line]

   MsgBox "Hello World!"

 Step 6: Click "File" -> Close and return Microsoft Excel.


  Note that the Macro has 3 lines. 
    Sub hello()
        MsgBox "Hello World!"
    End Sub

/////////////////////////