Standard VBA Macros must be made PUBLIC and located in the System_Macros module and it will show up in:
- Tools > Run Macro from the shell
- 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.