Control problem

[mitech]

Hi
A few years ago i programmed a excel sheet in 2003 and now when we run it with 2007 years version we got error "Can't exit design mode because control can't be created". The confusing thing is that the control that is causing the problem, cboMeny, isn't on any sheet anymore. But when i hit F2 in vba mode i can see it as a member. Any suggestion how to fix this problem?

Regards
Michael

 

[AlphaFrog]

Do you have code in the Workbook_Open event procedure that adds controls?

Perhaps cboMeny is on a sheet but its .Visible property is set to False.

While in Excel 2003, you might try to run a macro to loop through the sheets and delete cboMeny e.g.

Sub Delete_cboMeny()
    Dim ws As Worksheet
    On Error Resume Next
    For Each ws In Worksheets
        ws.Shapes("cboMeny").Delete
    Next ws
End Sub

 

[mitech]

Oh yes. That did solve the problem. Thank you