macros, selfcert, portability

G

George

(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top