how to check check if access to VBA is trusted

[bagullo]

Hi,

I have a macro that needs access to VBA editor to run smoothly.
Is there some easy way to check if it's not trusted so I can warn the user?

right now I get the error when trying to copy modules, but I'd like something easier to avoid creating a file and copying modules just to check that.

thanks!

[bagullo]

oh well,

I figured out I only had to export a module to see if error occurs, so a function like that will do the trick!

maybe it will help somebody out there too

i wonder if there is a read-only property somewhere that does the same

Please Login or Register  to view this content.

[romperstomper]

It's stored in the registry. A bit close to breaking security for me to say more than that, I think.

[bagullo]

I see

in that case my little function is the prize winner for non-dangerous programming :D