Gerardo,

A very popular question.....
You can't "detect" if macros are enabled.
What you can do is make your workbook unusable (by VeryHiding sheets).
If macros are enabled, you'd unhide the sheets via code.
Search Google for "Force Macros" to find a lot of threads on this subject.

John

Gerardo wrote:

Is there any way to detect if macros were disabled when a file is open ?
I'd like to automatically close a file if macros are not enabled.

thanks !!

Thanks John !!

"John Wilson" wrote in message
...
Gerardo,

A very popular question.....
You can't "detect" if macros are enabled.
What you can do is make your workbook unusable (by VeryHiding sheets).
If macros are enabled, you'd unhide the sheets via code.
Search Google for "Force Macros" to find a lot of threads on this subject.

John

Gerardo wrote:

Is there any way to detect if macros were disabled when a file is open ?
I'd like to automatically close a file if macros are not enabled.

thanks !!