Checking if macros are enabled or disabled

[flashsam]

Hello,

I'm hoping someone can help me out here. I know that the other day i came across a question that someone had asked about forcing the user to choose 'enable macros' and that unless you're security settings are low then it's not possible.

I know that someone gave an alternative which was an auto_open macro that checked if the macros were active or not and if they were disabled then it gave you a message and then closed the file.

I've searched and i can't find it. If anyone knows where it is please let me know. I'd be most grateful.

Thanks,
Sam

 

[tusharm]

If macros are disabled, how can a macro check if macros are disabled?

The easy way to do this is to have a worksheet that says "Hey, bozo, enable macros if you know what's good for you." If macros are enabled, the Workbook_Open routine hides the 'bozo, enable macros' worksheet, and the Workbook_BeforeClose / _BeforeSave routine puts it back in place.

The smarter way is to create an add-in. For more, see http://www.mrexcel.com/board2/viewtopic.php?p=148963#148963

{snip}I know that someone gave an alternative which was an auto_open macro that checked if the macros were active or not and if they were disabled then it gave you a message and then closed the file.
{snip}

 

[flashsam]

Was a stupid question wasn't it!

Thanks for the link. I'll check that out now.

Sam

 

[tusharm]

Well, you'd be surprised how many people believe it should be possible!

Was a stupid question wasn't it!

Thanks for the link. I'll check that out now.

Sam