Keep the macro in the workbook and just share the workbook.

Darrol wrote:

How can I share and save macros to multiple users' computers? I can create
them and import one, but can't get the computer that imported the .bas file
to save it once excel is closed and reopened.

--

Dave Peterson