Share Workbook Excel Macro. To share an excel workbook. The easiest way to share a personal macro workbook with someone is to send them a copy of.
If you want to share your macros with someone else you can copy personal xlsb to the startup folder on other computers or copy some or all of its macros to the personal xlsb file on other computers. On the review menu choose share workbook. Sharing macros means sharing workbooks perhaps in the form of a master workbook on which all others can be based.
Copy macros to another workbook.
Step 1 write the macro to be shared in an empty spreadsheet. On the review menu choose share workbook. If you want to share just a few macros from your personal xlsb file you can copy those. In finder select go then hold down the option key and select library.
