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

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 wrote:

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

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:

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 wrote:

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

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

Stefi wrote:

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:

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 wrote:

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


--

Dave Peterson

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:

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

Stefi wrote:

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:

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 wrote:

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


--

Dave Peterson