It all depends on the security level. Check ToolsMacroSecurity

"snax500" wrote:

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