Hello,

Can you help me i have created a macro on my pc and i want to copy it to another persons pc, is there an easy way to do this?

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

thanks Katie I will give this a go...

Jane