Changing a User's Security to allow Macros to be trusted

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken Edwards - 25 Feb 2004 03:06 GMT

Hi

I have self-certified the macros in VBAProject.OTM. I have copied this VBAProject.OTM to the computers I want to use the macros. The computers are Windows 2K and XP OS and are on a peer to peer network. All computers either have Outlook 2002 or Outlook 2003. After setting Macro security to Medium so I can tell the computer to "Allow all macros from this Source", I find that setting is grayed out. Also, "Trust VBA Project" setting on the Trusted tab is grayed out as well

Can anyone tell me how to get these computers to let the user changed the appropriate settings? I would like to keep the computers with Medium Macro security setting, but avoid the Enable Macros screen.

Reply to this Message

Paul Overway - 25 Feb 2004 04:00 GMT

A certificate generated using selfcert.exe is only good on the PC it was
generated on. You need to buy a digital certificate, publish a certificate
on a certificate server, or use selfcert on each target PC.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

> Hi,
>
> I have self-certified the macros in VBAProject.OTM. I have copied this VBAProject.OTM to the computers I want to use the macros. The computers are

Windows 2K and XP OS and are on a peer to peer network. All computers
either have Outlook 2002 or Outlook 2003. After setting Macro security to
Medium so I can tell the computer to "Allow all macros from this Source", I
find that setting is grayed out. Also, "Trust VBA Project" setting on the
Trusted tab is grayed out as well.

> Can anyone tell me how to get these computers to let the user changed the appropriate settings? I would like to keep the computers with Medium Macro

security setting, but avoid the Enable Macros screen.

Reply to this Message

Ken Edwards - 25 Feb 2004 05:26 GMT

Thanks, Paul

I thought that might be a possiblitiy, so I did use selfcert on one of these computers. The same problem of the controls being grayed out still persisted.

Ken

----- Paul Overway wrote: -----

A certificate generated using selfcert.exe is only good on the PC it was
generated on. You need to buy a digital certificate, publish a certificate
on a certificate server, or use selfcert on each target PC.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

"Ken Edwards" <anonymous@discussions.microsoft.com> wrote in message
news:5B46309A-788D-4C29-A280-C615834474B1@microsoft.com...
> Hi,
>> I have self-certified the macros in VBAProject.OTM. I have copied this
VBAProject.OTM to the computers I want to use the macros. The computers are
Windows 2K and XP OS and are on a peer to peer network. All computers
either have Outlook 2002 or Outlook 2003. After setting Macro security to
Medium so I can tell the computer to "Allow all macros from this Source", I
find that setting is grayed out. Also, "Trust VBA Project" setting on the
Trusted tab is grayed out as well.
>> Can anyone tell me how to get these computers to let the user changed the
appropriate settings? I would like to keep the computers with Medium Macro
security setting, but avoid the Enable Macros screen.

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Feb 2004 00:30 GMT

Is the Digital Signature for VBA Projects component from the Office Shared
Features component list installed? Rerun setup if you don't know for sure.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Thanks, Paul
>
> I thought that might be a possiblitiy, so I did use selfcert on one of these computers. The same problem of the controls being grayed out still

persisted.

> Ken
>
[quoted text clipped - 22 lines]
> appropriate settings? I would like to keep the computers with Medium Macro
> security setting, but avoid the Enable Macros screen.

Reply to this Message