How to mak a macro work when I open a new workbook?

I finally got a macro working for what I need only problem,
When I open my workbook and it is a new workboo each day the macro was in the original workbook.
Is there a way to make the macro available in a new workbook?

Thanks
Charles

http://www.fontstuff.com/vba/vbatut03.htm

take a look at this. What you might want to do is install it as an add in and be able to use it in every workbook that you open... I don´t know if this will help, but hopefully it will!