I have created a macro that will perform certain tasks on an excel
spreadsheet that is generated everyday. I want to give this macro to my
co-workers so that they can use it too. Because it is a new .xls file
every day, I can not just attach the macro to the workbook and send it
out. Is there an easy way to give them my macro or create a menu or
button on their taskbar that would run this macro? I would want this
macro to be available anytime they open excel.

Thanks!!

Do a search for creating an addin for excel. Alternatively you can
place it in personal.xls but I don't think you want to paste your code
into all of your coworkers personal.xls files.

HTH

Die_Another_Day

dan wrote:
I have created a macro that will perform certain tasks on an excel
spreadsheet that is generated everyday. I want to give this macro to my
co-workers so that they can use it too. Because it is a new .xls file
every day, I can not just attach the macro to the workbook and send it
out. Is there an easy way to give them my macro or create a menu or
button on their taskbar that would run this macro? I would want this
macro to be available anytime they open excel.

Thanks!!