Ok I've figured out how to save the macro into the document and how to save the template as a macro enabled template. Though it asks if I wish to enable content for macros, can I set it so that it's a trusted document and macro's in it are always avaliable?

It seems I have to manually run it, isit possible to have it so that whenI click the 'save' icon that it will run the macro and the correct directory will be displayed for saving into.

Or maybe as an alternate, when I press CRTL+S?

Thanks,
Ryan.