how to vba force user to trust center and enable all macros?

[Step01]

because i want user to use the userform when they open up the excel workbook.
i had set workbook_open to open the userform when user open the excel file but they are need to enable content so they can bypass the userform via not click the enable content.

so did any way to write an vba to force user to trust center and enable run all macros?


Thanks.

[TMS]

I guess that would rather defeat the object of having Trust Center Settings, wouldn't it? You send me a workbook that I open and run that doesn't do anything noticeable but, in the background, it tears a FOB hole in my security settings. Then you send me another workbook that just executes and does whatever it wants. I don't think so.

[dominicb]

Good morning Step01

There is no concrete way to force a user to accept macros, and certainly no way to access the trust Centre via VBA - all this is very deliberately not exposed to the VBA object model - for very good reasons.

That said there are some techniques which may help "persuade" a user that it may be a good idea to allow macros to run.

Two such techniques are discussed here. Neither are perfect but staying within the confines of Excel, it's the best you're going to get.
http://www.cpearson.com/Excel/EnableMacros.aspx
http://www.cpearson.com/Excel/EnableMacros2.aspx

HTH

DominicB

[Zer0Cool]

As mentioned already this is not really possib... or better put recommended, as it would defeat the purpose of such protections put into place.

Its generally a bad idea to alter any users settings via VBA, you are just asking for them to come after you with pitchforks and torches even if you had good intents. As soon as something doesnt work the way it should/they expect, it becomes your fault and most companies/people will hold you accountable. You are much better off providing people directions for use.

There are perimeter issues to consider too. If they get the file from the internet or network drive Windows can place a block on the file too, so even if you trust it in Excel, it still wont work right.

Also, what if the user cant change trust center settings themselves due to Group Policy or other rules enforced by an IT dept? Then even if you had code to enable macros it couldnt change the setting.

Lastly, its chicken and egg...How can you run your macro to alter the trust center to allow running macros if you cant run macros?

Despite my better judgement, heres a link to help you start should you want to try this...

https://msdn.microsoft.com/en-us/vba...property-excel

The settings for this are exposed to the object model afterall...