Missing Common Controls 6.0 (SP6)

[pbt]

I recently bought a new computer running 64 bit. Some of my macros that were running on a 32 bit no longer work on the 64 bit. I am getting error's stating "Compile error: Can't find project or Library". Going into the VBA References, it shows me Missing Common Controls 6.0 (SP6)

I have done searches on the internet and most of them refer to Access problems or problems after switching to IE10. I am running IE 11. I even found a link from MS to download the 6.0 Controls, but still have the problem.


One of the VBA code's that is producing the error is:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Dim sht As Worksheet
    Dim intResponse As Integer
    Dim intResponse2 As Integer
    
    '//Inserts the path in the footer of sheet
       With ActiveSheet
             .PageSetup.LeftFooter = "&8" & _
            ThisWorkbook.FullName
            End With
    
    '//Prompts the user for a date if printing the PROPOSAL
    If ActiveSheet.Name = ("PROPOSAL") Then
        intResponse = MsgBox(Prompt:="INSERT TODAY'S DATE?", _
        Buttons:=vbQuestion + vbYesNoCancel, Title:="REMINDER")
        Select Case intResponse
            Case vbYes
                Range("F2") = Format([B]Date[/B], mmmm, dd, yyyy)
            Case vbNo
                Exit Sub
            Case vbCancel
                Cancel = True
        End Select
     End If
        
End Sub

The word Date in Range("F2") = Format(Date, mmmm, dd, yyyy) is highlighted in Blue. Clicking on the OK button, the Macro name is highlighted Yellow. Clicking on the Reset button the code runs.

I can't figure this out and need some help from you guys.

Thanks.

 

[mrmmickle1]

Take a look at this article it may help with your issue, originally posted by Ken Puls (Excelguru Help Site - Welcome). In order to use the code you may need to do the following seeing as the code references the VBA Project Object Model. In the article it says it's only been tested in 1997 and 2003 but, it may be a start.

File > Options > Trust Center Settings > Macro Settings > Then check the box that says Trust access to the VBA project object model

VBA Express : Excel - Remove Missing VBA Library References via code