Macro Security settings

[pavin]

I need a VBA code to set Macro Security settings to Low/Medium on Workbook open ? Can anyone help me please

 

[VoG]

That's not possible - it would defeat the object of having macro security.

I'm guessing that you want to force users to enable macros - if so see http://www.mrexcel.com/forum/showthread.php?t=255533

 

[Peter_SSs]

I need a VBA code to set Macro Security settings to Low/Medium on Workbook open ? Can anyone help me please

No, if you could do that macro security would be absolutely useless!

However, if you search the forum, there have been some topics that suggested methods to force the user to enable macros otherwise they are unable to effectively use the workbook.

 

[Gary McMaster]

I believe that is impossible via VBA. If you could do it, so could some hacker who would think formatting your hard drive was funny.

Gary