Signing excel apps via a digital certificate can help guarantee that no one has tampered with the code and that what you are executing is what was originally written by the original signer. Further, it helps lock down your security policy. By only running signed code and only importing certificates from people you trust, you can prevent a situation where an an excel document can hijack your whole computer (because it can)

If you rely on VBA solutions within your organization, make sure you sign and then import certificates for all projects.

Sign with Certificate

When creating a VBA project that uses Macros, you can easily sign the project with a self signed certificate using the following steps:

1. If you don’t already have one, you’ll need to create a self-signed certificate on your computer. If you do have one, you can skip to step 3. If not, go to the Start Menu > All Programs > Microsoft Office > Microsoft Office Tools > and open Digital Certificate for VBA Projects
   
   • 
2. Enter a name for your certificate and Click OK
   
   • 
3. Open up your VBA project in Excel, Word, Outlook (etc) and hit Alt + F11 to open up the VBA Project and go to Tools > Digital Signature
   
   • 
4. On the Digital Signature Menu, Click “Choose”
   
   • 
5. You should see the Certificate we just created. Select that and hit OK
   
   • 

Import Certificate From Someone Else

When the file is opened on another machine, it won’t recognize the original certificate which only exists on the original author’s machine. Using the following steps we can import the certificate on the client’s machine.

Disclaimer: You should only perform these steps when you are absolutely certain that the file has originated from someone you trust to execute any commands on your machine without your knowledge.

1. Open the Excel File with Macros and click “Options”
   
   • 
2. Click “Show Signature Details”
   
   • 
3. Click “View Certificate”
   
   • 
4. Click “Install Certificate”
   
   • 
5. Install Wizard Will Open
   
   • 
6. Select “Place all certificates in the following store” and Click “Browse”
   
   • 
7. Select “Trusted Root Certification Authorities”
   
   • 
8. Click OK / Next several times
   
   • 
9. Accept the Security Warning to Install the Certificate
   
   • 
10. On the original Dialog, Select “Trust all documents from this publisher” and Click OK
    
    • 

Manage Certificates

If you want to go in and make changes to your certificates directly, you can view and edit all of the certs on your current system with the following steps.

1. Hit Win + R to open up the Run Dialog
2. Type “certmgr.msc” and Click OK
   
   • 
3. You should see the certificate we added in the Personal/Certificates folder
   
   • 

Alternatively: You can also load your Computer’s Management Console by going to Start > Run mmc and then going to File > Add Snap In and then selecting Certificates.

And that’s it! Adding certificates to your projects is a great way to keep security in mind while providing some sort of automation within Office and other products.

You guys might already know this, but I just learned something new about excel.

1. On the “Page Layout” Ribbon, click the “Print Titles”.
   
2. Click “Rows to repeat at top,” and click the icon that looks like a spreadsheet.
   
3. Use your cursor to click and select the row you wish to appear at the top of every page.
4. Press the Enter and Click OK

You can use print preview to show you what it will look like.

P.S. For long printed documents, don’t forget to also add page numbers:

1. On the “Insert” Ribbon, click “Header & Footer”
   

2. Click on the Header or Footer area in which you’d like the messages to appear. This should open up the Header & Footer tools Context Sensitive Designer Ribbon.
   

   

3. Then select Footer and insert any template or design you own
   

   This should insert the insert the text “Page &[Page] of &[Pages]” where “&[field]” will be replaced automatically

4. You can also choose from any of the following fields:

   Element Name	Text
   Page Number	&[Page]
   Number of Pages	&[Pages]
   Current Time	&[Time]
   Sheet Name	&[Tab]
   File Name	&[File]
   File Path	&[Path]&[File]