What wrong is macro with signcert?
 

I have been setup signcert within office 2003, and assign its cert into
macro, so I can skip the security pop up message whenever I open this file
and it works properly. Recently, I need to assign password for my XP user
account in order to enable hibernation mode, then when I open the worksheet,
it pops message for macro security again, but this time, the select option is
disable for always trust this cert, so I need to manually select enable macro.
Does anyone have any suggestions on how to solve this signcert issue?
Thanks in advance for any suggestions
Eric

What wrong is macro with signcert?
 

When I re-create a new self-cert, it pops up an error during setup, and not
able to be established.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

"Eric" wrote:

I have been setup signcert within office 2003, and assign its cert into
macro, so I can skip the security pop up message whenever I open this file
and it works properly. Recently, I need to assign password for my XP user
account in order to enable hibernation mode, then when I open the worksheet,
it pops message for macro security again, but this time, the select option is
disable for always trust this cert, so I need to manually select enable macro.
Does anyone have any suggestions on how to solve this signcert issue?
Thanks in advance for any suggestions
Eric

What wrong is macro with signcert?
 

I am using XP with SP3 and Office 2003
When I generated the certificate using Selfcert, and assign it into
worksheet to skip security of macro, and it works fine, but after I add
password into my username in order to use schedule tasks, when I open the
same worksheet, it pops up security message to enable macro, but the option
"Always trust macros from this publisher" is greyed out.
Does anyone have any suggestions on how to solve this issue?
Thanks in advance for any suggestions
Eric

What wrong is macro with signcert?
 

Sounds like you changed more than just adding a password to your account.

You may have also severely limited what you have permission to do.

Can you run MMC......Microsoft Management Console.......with certificates
snap-in loaded?

In Personal Certificates do you see your original selfcert?

Can you drag it to the Trusted Publishers folder?


Gord Dibben MS Excel MVP

On Sun, 25 Apr 2010 19:24:01 -0700, Eric
wrote:

When I re-create a new self-cert, it pops up an error during setup, and not
able to be established.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

"Eric" wrote:

I have been setup signcert within office 2003, and assign its cert into
macro, so I can skip the security pop up message whenever I open this file
and it works properly. Recently, I need to assign password for my XP user
account in order to enable hibernation mode, then when I open the worksheet,
it pops message for macro security again, but this time, the select option is
disable for always trust this cert, so I need to manually select enable macro.
Does anyone have any suggestions on how to solve this signcert issue?
Thanks in advance for any suggestions
Eric

What wrong is macro with signcert?
 

Thank you very much for suggestions
Eric

"Gord Dibben" wrote:

Sounds like you changed more than just adding a password to your account.

You may have also severely limited what you have permission to do.

Can you run MMC......Microsoft Management Console.......with certificates
snap-in loaded?

In Personal Certificates do you see your original selfcert?

Can you drag it to the Trusted Publishers folder?


Gord Dibben MS Excel MVP

On Sun, 25 Apr 2010 19:24:01 -0700, Eric
wrote:

When I re-create a new self-cert, it pops up an error during setup, and not
able to be established.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

"Eric" wrote:

I have been setup signcert within office 2003, and assign its cert into
macro, so I can skip the security pop up message whenever I open this file
and it works properly. Recently, I need to assign password for my XP user
account in order to enable hibernation mode, then when I open the worksheet,
it pops message for macro security again, but this time, the select option is
disable for always trust this cert, so I need to manually select enable macro.
Does anyone have any suggestions on how to solve this signcert issue?
Thanks in advance for any suggestions
Eric

.