Copying a macro as an add-in

Hi Sarah

Thanks for your question

In principle the answer to your question is yes. All you do is save the workbook containing the macro as an add in file. Click save as and choose excel add in from the file type combo box. You then click on the office button, go to options in use the add ins page to make the add in available


In reality however there are practical problems with recording a macro which would make it very difficult to create some thing that works. You would need to write your code from scratch, and this would require some VBA training

Hope this helps

Regards

Stephen