Can I have opinions please?
I have a panel of user setting options hosted in ActiveX controls. Users make a selection and click a button. This hides the panel and presents results. Another button deletes the results and makes visible again the panel of ActiveX objects
Hiding works, but when the ActiveX objects are made visible again Listbox ActiveX controls (not others) no longer function, as if I am in Design Mode. I get this problem in Excel 2013, it was working in Excel 2010.
I have seen similar issues solved with MS Office updates, but I don't have the exact symptoms they describe. I don't expect I can persuade my IT department to role out MSOffice updates, if necessary, workarounds are welcome.
Code snip-its below. If i comment this out this section of the hide sub the problem doesn't occur.
Sub HideFilters()
...
For Each shp In ActiveSheet.Shapes
If Left(shp.Name, Len("AutoShape_Index_")) <> "AutoShape_Index_" Then
If Left(shp.Name, Len("Gant_btn")) <> "Gant_btn" Then
shp.Visible = False
End If
End If
Next
'''
End Sub
Sub ShowFilters()
...
For Each shp In ActiveSheet.Shapes
If Left(shp.Name, Len("AutoShape_Index_")) <> "AutoShape_Index_" Then
If Left(shp.Name, Len("Gant_btn")) <> "Gant_btn" Then
shp.Visible = True
End If
End If
Next
...
End Sub