How can I share a macro with my co-worker that I saved on my own computer as an .xlsm file?

[dtarockoff]

I just recorded a macro that I saved to my Personal Macro Workbook on my mac computer with Excel for Mac 2011. I want to share this with my co-worker who has a PC with Excel 2007. I saved the file with the macro recording saved as an .xlsm and then e-mailed it to him, but we couldn't figure out how to get it to work. He was able to open the .xlsm file but when he opened a separate Excel file to test the macro on, it wouldn't show up for him to run.

Hopefully I explained that well enough. Does anyone know how I can successfully share this with him without having to re-do the entire macro on his computer? Thank you!

 

[sergioMabres]

You have a couples of ways of doing what you want
1. Export the module to a .bas file, copy the .bas file to other pc and import the module into excel workbook
2. Copy code to a mail, mail the text and re create macro in the other pc
3. Copy .xlsm file as personal macro file, you could loose if he already has macro on it

He does not see your macro probably due to security settings
Cheers
Sergio

 

[dtarockoff]

Thanks so much Sergio! I've already headed out of the office for the day but I'll try these tomorrow. If I run into any issues I'll post again, but it sounds like I'll be able to figure it out. I appreciate the help.