As a guess you want to create an addin from the code that you have. A quci
search of this forum and or the help files should get you started...
--
HTH...

Jim Thomlinson


"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.