Home |
Search |
Today's Posts |
#1
|
|||
|
|||
macros, selfcert, portability
(Excel 2002, SP3)
I have just written some VBA pgms, for the first time. In the course of doing this, I had to sign them. (I don't know if this is always true, or if I just took a wrong turn somewhere.) So, I did the self-cert thing. After doing that, I could run the macros with macro security set high. I was able to run the same WS on another PC with Excel 2002, after I "added the certificate" to the "trusted persons root". I can't say I had a clear picture of what I was doing, but it seemed to work. When I try to run the same WS on a PC with Excel 2003, I get a msg that macros are disabled, but I see no way to add my self-cert to the trusted list. That option is grey-ed out on the warning message, and on the <tools - macros - security dialog. The only choice offered is to get a certificate from a "certifying authority", or run at low security. Questions: - Is that really happening, or am I just confused? That is, does XL 2003 have different rules than XL 2002? - If 2003 is different, is there a way to use a self-cert'd imported macro? (That is, while leaving macro security 'high'.) Thanks, George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Purge macros | Excel Worksheet Functions | |||
Remove macros from spreadsheet | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) |