You should not be saving this as .xls. Please refer the below link
http://www.ozgrid.com/VBA/excel-add-in-create.htm

If this post helps click Yes
---------------
Jacob Skaria


"Dottled" wrote:

I would like to create a macro that I can use on different workbooks - I
have to create a new spreadsheet every day (exporting data as *csv and
converting to .xls but the information is similar - I have read other answers
and I don't really understand the replys (and have tried saving my last
workbook with the macro in as Addin*,xls file to save the macro for further
use but that didn't work)
Thank you in advance for any replies