- 1). Write the macro to be shared in an empty spreadsheet. Click the "View" tab on the ribbon menu. If you are going to record the macro, click the small arrow at the bottom of the "Macros" button and then select "Record Macro..." from the drop-down menu. If you elect to write the macro using Visual Basic for Applications, select "View Macros..." from the drop-down menu. Provide a macro name and click "Create" on the "Macro" dialog.
- 2). Save the spreadsheet as an "Excel Macro-Enabled Workbook" file. If the macros are saved in other types of Excel files, they may not be visible due to internal security settings.
- 3). Distribute the Excel workbook master file to those co-workers with whom you want to share the macro. When a user bases a workbook on this master file, the macro remain embedded.
previous post