Macros Disabled when opening file

[snax500]

In Excel2000, I have many files with macros. Some of the files open
with the Enable Macro buttons. Some open without the prompt. These
files then have their macros disabled. Why is this happening?

Thanks

 

[bigwheel]

It all depends on the security level. Check Tools>Macro>Security