# Sending an Excel Macro

**URL:** <https://boards.straightdope.com/t/sending-an-excel-macro/184105>\
**Category:** Factual Questions\
**Created:** [June 24, 2003, 6:58pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184105 "2003-06-24T18:58:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![daniel801](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@daniel801](https://boards.straightdope.com/u/daniel801)\
**Post date:** [June 24, 2003, 6:58pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184105/1 "2003-06-24T18:58:40Z")

</div>

So I have a homemade Excel macro saved to my personal.xls  
How can I send the macro to a coworker so that he has it as part of his personal.xls? Thanks.

---

<div class="post-metadata">

**Author:** ![CookingWithGas](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/cookingwithgas/32/485_2.png) [@CookingWithGas](https://boards.straightdope.com/u/CookingWithGas)\
**Post date:** [June 24, 2003, 7:11pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184105/2 "2003-06-24T19:11:18Z")

</div>

One way is to edit the macro and copy the code. Tools \> Macro \> Macros \> Edit.

First you will have to unhide your Personal Workbook to edit a macro in it. Window \> Unhide \> Personal.xls

Your friend would have to create the macro by pasting into a macro with the macro editor, in reverse of your process for copying it.

---

<div class="post-metadata">

**Author:** ![bibliophage](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/bibliophage/32/7615_2.png) [@bibliophage](https://boards.straightdope.com/u/bibliophage)\
**Post date:** [June 24, 2003, 8:07pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184105/3 "2003-06-24T20:07:57Z")

</div>

Accidental duplicate post. See [http://boards.straightdope.com/sdmb/showthread.php?s=&threadid=193123](http://boards.straightdope.com/sdmb/showthread.php?s=&threadid=193123)