Open the VBE (Visual Basic Editor)
The Alt-F11 key combination
will open the VBE in Excel, Expression Web and Word.
Click on the Tools Menu and then click on References.
You will see several references near the top with a checkmark.
The Microsoft Visual Basic for Applications Extensibility 5.3
reference has to be listed with with these available references.
If it is not, you need to scroll down the
alphabetical listing and find it and place a check mark next to it.
Nothing here will work without the Microsoft Visual Basic
for Applications Extensibility 5.3 reference.
Next click on the View Menu. Make sure the
Project Explorer, Properties Window, Immediate Window and Watch
Window are all chosen.
Make sure the 4
windows listed above are visible on your VBE desktop.
Leave the name of the module as Module1.
need to enable Trust access to the VBA Project Object Model.
This is located in different areas for each Office program.
In Excel 2007 and Word 2007, the location is:
||Top left part of the Word or Excel screen.
|Word Options or Excel Options Button
||Bottom of Office Button Window just left of the Exit
Word or Exit Excel button.
|Trust Center Button
||On the left side of the Word Options or Excel Options
|Trust Center Settings Button
||On the right side of the Trust Center Window.
||On the left side of the Trust Center Settings Window.
The Window in Word 2007 will look like the following:
Make sure the Trust access to the VBA project object model is
checked at the bottom of this window.
also add a
This digital signature link can lead you through the process. It is
free and fairly straight forward.
You may also
have to click the Enable all macros temporarily button if you don't
have a digital signature.
Once you get your
digital signature setup, you can change it to Disable all macros
except digitally signed macros.