Hi all,
I'm trying to make a change in the macro security via vba,
i know that there is an option like this in access for hide or show the
toolbar
all i need to do is
enter "tool"
go to "macro"
"then "security
choose and "trusted publishers" tab
and "check" or "uncheck" the "Trust Access To Visual Basic Project

any ideas?

For good reason, it can't be done.

You might be able to do something through sendkeys, but I have not tried it,
and would be very annoyed if someone did try it on my machine through code.

Robin Hammond
www.enhanceddatasystems.com


"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all,
> I'm trying to make a change in the macro security via vba,
> i know that there is an option like this in access for hide or show the
> toolbar
> all i need to do is
> enter "tool"
> go to "macro"
> "then "security
> choose and "trusted publishers" tab
> and "check" or "uncheck" the "Trust Access To Visual Basic Project
>
> any ideas?
>

unfortunately the use of sendkey for this metter is an optional,it is
working as i wanted but i prefer to have a normal member/controls
procedure instead
i have an example of something close
CommandBars("Menu Bar").Controls("Tools").Controls("Database
utilities").Controls("Compact and repair
database...").accDoDefaultAction

Robin Hammond ëúá:
> For good reason, it can't be done.
>
> You might be able to do something through sendkeys, but I have not tried it,
> and would be very annoyed if someone did try it on my machine through code.
>
> Robin Hammond
> www.enhanceddatasystems.com
>
>
> "thread" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi all,
> > I'm trying to make a change in the macro security via vba,
> > i know that there is an option like this in access for hide or show the
> > toolbar
> > all i need to do is
> > enter "tool"
> > go to "macro"
> > "then "security
> > choose and "trusted publishers" tab
> > and "check" or "uncheck" the "Trust Access To Visual Basic Project
> >
> > any ideas?
> >