To copy the macros to another database, open the other database, then choose from the File menu “Get External Data” and “Import”. Select the Macros tab on the Import Objects dialog.
Push the Select All button and then push the OK button.
More:
Using the macros in Access