Link to home
Start Free TrialLog in
Avatar of Frank Freese
Frank FreeseFlag for United States of America

asked on

Run-time error 57121

Experts,
My workbook was created in 2010 and needs to run under 2003. There are some macros in the workbook. When I open it in 2003 it goes through a conversion and then pops up:
Run-time error 57121
Application-defined or object defined error and debugs at the With state:
Sub Workbook_Open()
Dim ws As Worksheet
With Sheets("Home").OLEObjects("cboSelectSpreadsheet").Object
    .Clear
    For Each ws In ThisWorkbook.Worksheets
        If ws.Name <> "Home" Then .AddItem ws.Name
    Next ws
End With

End Sub

Open in new window

This workbook works fine in 2010 but the users use 2003
ASKER CERTIFIED SOLUTION
Avatar of TommySzalapski
TommySzalapski
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Frank Freese

ASKER

the object in question is a combo box.
when trying to save as 2003 wb I'm advised some functionaly maybe lost