macro's shared between workbooks

[mrjwalsh]

Hi all,
I recently upgraded to Office 2007 and I'm having some trouble with my macros. I currently have a workbook named MACRO.xls in my Excel startup folder in Application Data and in that are all my macro scripts. I use them accross all different workbooks but for some reason I cannot use them in any new workbooks, even while MACRO.xls is still open. I also tried saving it as MACRO.xlsm but that didn't seem to work. Thanks.

[royUK]

Why not crete an addin from your macro book?

have you enabled macros in your 2007 macros.xlsm?

Read this for help setting up Trusted location

http://blogs.msdn.com/excel/archive/...01/672308.aspx