Hello BigPat,
This is pretty simple to do, once you know how. First, you need to create a digitally signed certificate. You won't be able to run the macros in Outlook without it. This is the most complex part of the procedure here is how to create your digital certificate. You may want to print this for reference.
Program Location:
For Office 2003:
?:\Program Files\Microsoft Office\OFFICE11\SELFCERT.EXE
For Office XP:
?:\Program Files\Microsoft Office\OFFICE10\SELFCERT.EXE
etc.
If you do not have the SELFCERT.EXE program you can find it on
your office CD or you can run setup again and install the Office
Tools.
Create the Digital Signature
Run the program and follow the simple step. It will create the
Digital Signature or "Certificate" for your vba projects.
Then in the VBA editor click Tools > Digital Signature... and click
Choose button and select the certificate you just created.
This will attach the signature to the project.
You can also set the security on Excel to High - only signed macros
from trusted sources will be run.
So only your macros will run.
To make you Digital Signature Certificate "Trusted"...
Export the Digital Signature
After you create your D.S. view it like when you assign the D.S. to
your VBA project - Tools > Digital Signature > Choose... > Select
your certificate > View Certificate > Details Tab > Copy to file...
Then you will see the Certificate Export wizard. Click Next > Next
> Next > Browse to where you want to save it to (*.cer) > Next >
Finish.
Import the Certificate
Browse to where you exported the certificate to and double click
it and wait for it to display the certificate. Then click Install
Certificate... > Next > Select "Place certificate in the following
store." and browse to "Trusted Root Certification Authorities" >
Next > Finish > Yes. Then your done.
Then check your VBA project's Digital Signature and it should
show that it is now "Trusted". If not, remove the Digital Signature
and then re-attach it to your VBA project again. You wil no longer
see the little red circle x before the certificate name.
Macro Code
This will create the button to "Choose a Form".
Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open Outlook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Outlook.
Outlook Startup Event Macro
Installing the Event Macro
1. Copy the macro using CTRL+C keys.
2. Open Outlook
4. Press ALT+F11 keys to open the Visual Basic Editor.
5. Press CTRL+R keys to shift the focus to the Project Explorer Window
6. Press the Down Arrow Key until ThisOutlookSession is highlighted in blue.
7. Press the Enter key to move the cursor to the Code Window
8. Paste the macro code using CTRL+V
9. Save the macro in your Workbook using CTRL+S
Sincerely,
Leith Ross
Bookmarks