Hello,

I have three different macros, all saved in a blank .xlsm file (a maco saved workbook file), I sent the workbook to my coworkers so that they can open the file and run the macros. The problem is they cannot see or use the file and the macos will not work.

We have tried

1) VBEditor, export the module to a file and then e-mail them that file.
They imported the module.
2) Put your module in an empty workbook. In a different module, AND also copy the copied the code in email and sent exported the modules so that they can import
3) Tried Add in (which some could not understand how to do)

None of the above has worked.

Any help would be appreciated.

I know this can work because we had another co worker create a blank macro worksheet and sent to the team in via email and it works. Why can’t the same procedure work?