Hi,

I have a Excel template with Activex & Form controls with Macro code. It's working fine with Excel 2010 version.

I am getting error 'Run-time error '438': Object doesn't support this property or method' when i use Excel 2013 version.

This error throwing for below macro snippet: (chkActive is Form control Checkbox)

If Sheet6.Cells(12, "M") = "Yes" Then
        Me.Shapes.Range(Array("chkActive")).Select
        With Selection
            .Value = xlOn                         <===== Here, Runtime error occurs with 2013 template.
            .Display3DShading = False
        End With
    Else
        Me.Shapes.Range(Array("chkActive")).Select
        With Selection
            .Value = xlOff                     <===== Here, Runtime error occurs with 2013 template.
            .Display3DShading = False
        End With
    End If
Please help!!! Thank you.