Visual Basic for Applications (VBA) code will require you to import the Private Key.

To do this you will need a Microsoft tool called pvkimprt.exe
The download for this tool can be found at:
http://office.microsoft.com/downloads/2000/pvkimprt.aspx