How do I force users to enable macros on open?

[Maryz]

I’ve read that you can write code and make all worksheets VeryHidden except for a sheet informing users that they must enable macros. If macros are enabled, then the warning sheet becomes Very Hidden. One place tells me it can be done successfully, another posting I read says it is difficult to implement properly. Any thoughts/ideas? Is there a best way to do it?

 

[copleyr]

This is very helpful. Does anybody know how to do this code for powerpoint use?!