How to call a macro from VBA sheet code?

How to call a macro from VBA sheet code?

I've seen it written elsewhere that you can call a macro from the 'Worksheet_Change' event.  However when I try inserting the syntax:

Call My_Macro()

within the editor, this results in a dialog box that says "Click a Macro to run."  When I click the named macro, the code executes.
However, outside of the editor, the complete code doesn't execute.

Example:
  2. REM Sheet Module

  4. Sub Worksheet_Change(ByVal Target As Range)
  5. Application.EnableEvents = false
  6. On Error Goto ENEV
  7. REM add your code below
  8. Call Do_Sort()

  10. ENEV:
  11. Application.EnableEvents = true
  12. End Sub