| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vb macro format is wrong | New Users to Excel | |||
| Macro - Whats wrong? | Excel Worksheet Functions | |||
| What is wrong with this Macro? | Excel Worksheet Functions | |||
| Whats wrong with this macro please | Excel Discussion (Misc queries) | |||
| macro results wrong | Charts and Charting in Excel | |||
Hybrid Mode
