If you macros are in a personal workbook then this explains how they work and where you will find them.
http://office.microsoft.com/en-gb/ex...102174076.aspx
http://wheatblog.com/2011/08/where-i...kbook-located/