View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default macros disabled

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 !!