Where is (likely FAQ) info on safely running local Macros in OL 2003?

  • Thread starter Thread starter Herb Martin
  • Start date Start date
H

Herb Martin

I am trying to run macros that I wrote -- now in OL 2003 but of
course the macro protection is on and that is disabled.

Where is info on understanding how to enable this and the
risks involved?

Is there no way to say that they can be run manually but no
automatically in a message?

I suppose I could sign them but at the moment I have no
Certificate Server to issue the code signing cert.

Other suggestions welcome -- even RTFM as long as you
can PLEASE tell me which fine manual and preferably the
chapter or general area to start <grin>
 
You can use the Selfcert.exe tool that comes with Office to digitally sign
your macros. See http://www.outlookcode.com/d/vb.htm#selfcert

Thanks Sue.

Sometimes knowing too much (but not really enough <grin>)
is worse than knowing nothing -- figured that it had to be a
real cert server....

I take it that this is only valid on the machine where the
cert is created/performed? (That's all I need.)

--
Herb Martin, MCSE, MVP
Accelerated MCSE
http://www.LearnQuick.Com
[phone number on web site]
 
Herb Martin said:
You can use the Selfcert.exe tool that comes with Office to digitally sign
your macros. See http://www.outlookcode.com/d/vb.htm#selfcert
Click to expand...

I almost never found this for Office 2003 so though I
would feed this back for others -- neither the SelfCert.exe
nor any file with "self" nor "cert" is in either of the CDROM
directories nor in the Program Files\Microsoft Office install.

The feature is NOWHERE in the installed product (e.g.,
Outlook) as far as I can find.)

1) Office 2003 puts this feature on a menu in the startup
group Digital Certificate for VBA Projects:

Start->Programs->Microsoft Office->
Microsoft Office Tools->
Digital Certificate for VBA Projects

2) The documentation for this feature makes it clear that
the self-signed certificate can sign VBA code which
will ONLY be trusted on the same machine as the one
where it is created (to be expected since no one else
would have a trust certificate for this one.)

3) If you don't find the Digital Certificate for VBA Projects
then you must re-run the Windows 2003 Install program
and add this feature by using the custom choices.

--
Herb Martin, MCSE, MVP
Accelerated MCSE
http://www.LearnQuick.Com
[phone number on web site]

I've never tried it on another machine.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Herb Martin said:
You can use the Selfcert.exe tool that comes with Office to digitally sign
your macros. See http://www.outlookcode.com/d/vb.htm#selfcert
Click to expand...

I almost never found this for Office 2003 so though I
would feed this back for others -- neither the SelfCert.exe
nor any file with "self" nor "cert" is in either of the CDROM
directories nor in the Program Files\Microsoft Office install.

The feature is NOWHERE in the installed product (e.g.,
Outlook) as far as I can find.)

1) Office 2003 puts this feature on a menu in the startup
group Digital Certificate for VBA Projects:

Start->Programs->Microsoft Office->
Microsoft Office Tools->
Digital Certificate for VBA Projects

2) The documentation for this feature makes it clear that
the self-signed certificate can sign VBA code which
will ONLY be trusted on the same machine as the one
where it is created (to be expected since no one else
would have a trust certificate for this one.)

3) If you don't find the Digital Certificate for VBA Projects
then you must re-run the Windows 2003 Install program
and add this feature by using the custom choices.

I put this on my (new) blog http://www.HerbMartin.Com ...


--
Herb Martin, MCSE, MVP
Accelerated MCSE
http://www.LearnQuick.Com
[phone number on web site]

I've never tried it on another machine.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
I believe you mean the Office installation program.

Sure do, I corrected that in one window but was cut n pasting
and missed the other. Thanks

--
Herb Martin, MCSE, MVP
Accelerated MCSE
http://www.LearnQuick.Com
[phone number on web site]

I believe you mean the Office installation program.
 
Back
Top