trying to sign excel macros using VB windows form

[chrisdaden]

My goal is to create a windows form, that launches the excel workbook, and when it launches, sign it with my certification.

I would like the code to do this, i've been searching for ages and I cant seem to find it.

Please help!!!

here is the code below I use to open the workbook:

  Dim xlApp As Microsoft.Office.Interop.Excel.Application
        Dim xlWB1 As Microsoft.Office.Interop.Excel.Workbook
        xlApp = New Microsoft.Office.Interop.Excel.Application
        xlApp.Visible = True

        xlWB1 = xlApp.Workbooks.Open("non_signed.xls")

I need this to happen:

Step1: The form opens the excel workbook -- ALREADY GOT THIS

step 2: Signs the excel workbook macros -- THIS IS WHAT I NEED

step 3: Saves and closes -- ALREADY GOT THIS

Thanks- Chrisdaden