If you're still wondering what macros can do for you, it helps
to look at a few straightforward examples. In this section, you'll
learn about some helpful macros that you can create for practice and
Power Users' Clinic: Authenticode Macro Signing
If your company frequently creates and distributes workbooks
with macros, you may want to use an advanced option called
Authenticode signing. With Authenticode, you sign all
your macros with a digital signature. When someone opens the
workbook, their computer checks the signature, and verifies that
it's from a known, trusted source. If it's not from a trusted source, the
Security Warning dialog box appears (if Excel's using the standard
Medium security level), or Excel turns the macro off (if it's using
High or Very High security).
Authenticode macro signing is problematic, because the person
who opens the document needs a way to verify that the digital
signature's trusted. You need to create a digital
certificate for the person who writes the macro, and
register this digital certificate with everyone who needs to use
macros created by this person.
This process can be complicated, and large organizations that
use macros heavily go through it. Authenticode signing is far outside the scope of this
book, but you can download a document that explains this feature and
the technology it uses from http://office.microsoft.com/home. Just search for
macro security whitepaper.
Inserting a Header
A really simple macro to ...
With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.