Good afternoon, all. I have an Excel 2007 template that has several predefined custom properties, but am running into problems when trying to set them. Here are the details:

1. I've saved the template spreadsheet (.xlsm) as a content type within a SharePoint library. The file opens from there, and successful saves (this is somewhat flaky) publish the file into that same library.

2. Within the spreadsheet I have named ranges and set up custom properties that point to these named ranges. Ideally, the information from the named ranges will populate the custom properties, which will then be displayed in the correct columns within the SharePoint library.

3. I have a simple bit of code in place that is supposed to set the custom properties with data contained within the workbook. This code is currently button-triggered:

Sub Button2_Click()
    For Each Prop In ThisWorkbook.ContentTypeProperties
        If Prop.Name = "Proj_Title" Then
            Prop.Value = Range("Proj_Title").Value
        End If 
    Next Prop
End Sub
When I try to click on the button, however, I get an error message that I haven't been able to track down:

Run-time error '-2147023728 (80070490)': Unknown name.

Clicking on the dialog box's Help button yields this bit of information:

Cannot open the file mk:@MSITStore:mshtml.hlp>LangRef.

I have verified that I have every range named, and every range is attached to a custom property. The odd thing is that Excel actually does push the properties into the right properties, but this error message is obviously not desirable. What burns me the most is that this worked fine yesterday.

I welcome any help you can provide.

Thanks,

AP