Prev: cell reference as variable?
Next: is there a template to use pc as cash register
From: Eric on 25 Apr 2010 21:45
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
From: Eric on 25 Apr 2010 22:24
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
From: Eric on 25 Apr 2010 23:25
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
From: Gord Dibben on 26 Apr 2010 11:31
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 <Eric(a)discussions.microsoft.com>
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

From: Eric on 27 Apr 2010 18:35
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 <Eric(a)discussions.microsoft.com>
> 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
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: cell reference as variable?
Next: is there a template to use pc as cash register