Active Object VBA Macros are essentially event based macros and launch when the event fires. Active Object macros are associated with specific objects in The Raiser’s Edge, such as Constituents, Gifts, Campaigns, etc. and respond to specific actions, or events, that the user performs on the object.

Standard VBA Macros must be made PUBLIC and located in the System_Macros module and it will show up in:
  1. Tools > Run Macro from the shell
  2. Tools > User Options.  'Home' tab under 'Add these functions to my list of' (scroll to the bottom)

For more Please also review Frequently Asked Questions on the VBA, API and other optional modules available including what is VBA and API.