Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
George
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Purge macros Don_S Excel Worksheet Functions 1 August 16th 05 03:51 PM
Remove macros from spreadsheet Jan Buckley Excel Discussion (Misc queries) 1 August 12th 05 08:38 PM
Enabling macros Peter M Excel Discussion (Misc queries) 3 February 7th 05 10:57 PM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 12:21 AM
The available macros list in XL; how to suppress filename from showing KR Excel Discussion (Misc queries) 1 January 10th 05 07:20 PM


All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"