changing "trusted publishers" via vba

T

thread

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?
 
R

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
 
T

thread

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 ëúá:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
Excel 2007 and Trusted Publishers 3
Configuring Excel 2003 to control access to Trusted Publishers 0
Microsoft Project 2003 Macro Security 0
remove module via code 2
Trust access to visual basic project is grayed out 3
Add Trusted Publisher 0
"Trust Access to Visual Basic Project" checked but getting error 6 2

Top