Excel VBA, check if Macros are enabled

[greg0303]

How do you check if Macros are enabled and not load the worksheet if there are disabled?

 

[SkipVought]

Hi,

Well, put it this way. If macros were disabled, exactly WHAT would do ANYTHING, beings that the macros are DISABLED?

Skip,
[sub]
[red][/red]
[/sub]

 

[Rofeu]

Hi,

I'm assuming that you're trying to prevent users from using the workbook if the macro's are not enabled.

The only way to accomplish this, is by creating an extra sheet, maybe with a single message on it, that they need to enable in order for the workbook to be useable, and hide all the sheets expect that one, then set workbook protection.

You will need to use VBA to accomplish this. If you search in the VBA forum,

http://www.tek-tips.com/threadminder.cfm?pid=707,

you'll probably find loads of threads that deal with this.

Cheers,

Roel

 

[SkipVought]

Since this is a VBA related question, please post any further questions in Forum707.

Skip,
[sub]
[red][/red]
[/sub]