Is it in a sub-folder? Have you trusted the sub-folder?
Have you saved the file as a macro-enabled workbook? What's the file name?
When you open the file, does it warn you that content is disabled and offer you the chance to enable it or does it simply disable it?
How do you know macros are disabled?