Thread: How to email personal.xls macro sheet

I work on a desktop at work and have several macros stored in my personal.xls file. I also work on my laptop which logs in to the network so I have access to all my excel files but apparently it opens it's own personal.xls worksheet and I end up having to remember to copy any new macros into word and then pasting them when I get to my laptop. Is there any way I can email myself the personal.xls worksheet from my desktop to my laptop and save it on my laptop as the new personal.xls worksheet?

Thanks so much!

Create an add-in instead. Or export the module and mail it to yourself.

In the VBE project explorer window, select the module that contains the code of interest, and drag it into a directory or onto your desktop. Then email it to yourself, and then drag it into the appropriate VBA project on your other computer.