project protecting

[Stefi]

Hi All,

I've managed to create protected projects (workbooks) through VBA using
Sendkeys. It works on my computer but it should be run on other users'
computers and there VBA sends an error message saying (freely translated back
into English) "You have no access to programming properties of the project!".

How could I override this restriction?

Thanks,
Stefi

 

[Dave Peterson]

In xl2003, there's an option under:
Tools|Macro|security|Trusted publishers tab
Check that "trust access to visual basic project"

This is a setting for each user--you may have to fiddle with sendkeys again
(ouch!) if you want to mechanize it.

Personally, I wouldn't want you or your program touching my security settings.
If I had to do this, I'd make it a training issue and explain that the user has
to have this security setting if they want to run the rest of the program.

 

[Stefi]

Thanks Dave, it solved my problem. An ideal solution would be if VBA made a
copy of a workbook or a worksheet as protected project independently of the
user current security settings..

Regards,
Stefi


„Dave Peterson†ezt írta:

 

[Dave Peterson]

But that wouldn't offer the same level of security for the user, huh?

 

[Stefi]

Well, it can be a problem for an expert user like you. But my users are
laymen and the project is to be secured against them!
Stefi


„Dave Peterson†ezt írta: