mah121
02-14-2015, 01:59 AM
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.
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.