Refuse entry if Macros are not enabled

[dancey_james]

Hello,

Not sure if this very easy to set but I am struggling to find a way.

I really am after what the title states. I would like to refuse entry to a user who tries to disable Macros when entering my workbook.

Thanks

 

[VoG]

See if this helps http://www.mrexcel.com/forum/showthread.php?t=255533

 

[Michael M]

Hi
Technically, it can't be done.
However, you can force the user to enable macros by setting up another worksheet in your workbook, that carries a message that Macros must be enabled to continue, because all worksheets are hidden. While that will keep the average user out, it's very simple to get around. Excel security is renowned for being weak.