VBA Ref: Is there a way to check if "Trust access to VBA project object model" option is checked using VBA?

[gifariz]

I made a code to auto-update VBA library references using Ms VBA Extensibility library, so that user doesn't need to add/remove the required/incompatible references by themselves in VBE.
Apparently it needs permission from user's PC by checking the "Trust access to VBA project model", so I currently made message box at workbook open asking user to do this setting once.
But I want to show this message only if the "Trust access to VBA project object model" option is still not selected. Is there a way to check whether this setting has been applied using VBA?

 

[Tupe77]

Do you mean something like this?

Dim VBA_is_Trusted As Boolean
On Error Resume Next
VBA_is_Trusted = (Application.VBE.VBProjects.Count) > 0
debug.print VBA_is_Trusted
On Error GoTo 0

If it is not trusted, the calculation produces an error. If trusted, projects should be found.

My apologies for any quirks, English is not my native language. "So I blame Google translate for all my goofs."

 

[gifariz]

Do you mean something like this?

Dim VBA_is_Trusted As Boolean
On Error Resume Next
VBA_is_Trusted = (Application.VBE.VBProjects.Count) > 0
debug.print VBA_is_Trusted
On Error GoTo 0

If it is not trusted, the calculation produces an error. If trusted, projects should be found.

My apologies for any quirks, English is not my native language. "So I blame Google translate for all my goofs."

oh yes right! I can just use some error handling and prompt that message when there is error running the VBE library. Thanks!