excel-xp-training - Excel Macros

Hi Jane,

Thanks for your question.

You can try exporting the macro.

1. Open your Visual Basic window
2. In the Project Explorer window (top left corner), under the file PERSONAL.xls, you can see the MODULE folder
3. Right click on the particular MODULE name
4. Choose EXPORT FILE...
5. Name & save it.

Email this file (*.bas) to your colleague, on their computer.

1. Open a new Excel worksheet
2. Open Project Explorer Window
3. Right click on the new file name (e.g. Book1)
4. Choose IMPORT FILE...
5. Locate and press OPEN.

Hope this helps

Regards,

Katie