Re: project protecting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • Re: Unable to download/run ActiveX controls
    ... Your current security settings prohibit running Active X ... Test Your ActiveX Installation ... change the security settings for this zone? ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Big Security Permission Mistake - Please Help if You Can
    ... Reset Security Settings Back to the Defaults ... security template to be applied. ...
    (microsoft.public.windowsxp.configuration_manage)
  • Re: why microsoft choose mfc rather than wtl?
    ... One is that users need to keep their browser security settings as high as ... attacks that aren't possible in the higher security settings. ... point was that you should not dictate securiy settings to your customers ...
    (microsoft.public.vc.mfc)
  • RE: System Restore
    ... Security setting descriptionsComputer Configuration\Windows ... Windows XP Service Pack 2 introduces some security-enhancing changes to ... Account Policies Password Policy, Account Lockout Policy, and Kerberos Policy ... You can configure the security settings that are described in this section ...
    (microsoft.public.windowsxp.general)
  • Re: IE7, New User on Terminal Server
    ... When you create a new user on the TS, the profile is being created with more restrictive security settings than what the existing accounts have. ... This can cause a mapped drive to be considered in the Internet zone when accessed from 2003 whereas it is considered in the Local intranet zone under XP. ... If after verifying that the share is running in the correct zone you still are unable to run the program, check the security settings for the zone. ...
    (microsoft.public.windows.terminal_services)