Run-time error '57121', application-defined or object-defined error

[samicbc]

I have taken over a project for an employee who left, and I'm having some trouble with one of his excel workbooks. The file opens fine on my co-workers' computers but it fails when I try to open it on mine.

I get a pop up that says "File error: data may have been lost" when I open the workbook. I click 'ok'.

Then I get another popup that says "Run-time error '57121', application-defined or object-defined error". I click 'debug'.

It takes me into the VB editor, and this code line is highlighted:

Public Sub Workbook_Open()

Sheets("Search").ScrollArea = "$A$1:$Z$55" <--**highlighted line**

End Sub

Has anyone run into this problem before? Thanks for your help!!

 

[SkipVought]

Check in the Project Explorer to see if Sheet "Search" exists, or if it was LOST.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[combo]

A big part of work could be lost after such message (code, formatting, hyperlinks, objects). I would try to save as much of the project as possible:
1. On your co-worker's computer:
check references, export vbcomponents, remove code, move sheets to other workbook and save it under new name.
2. On your computer:
check if all references (and maybe extra components) are available, try to open original workbook with disabled macros, try to open a copy of workbook without macros and succesively import code and vbcomponents.

combo

 

[samicbc]

OK, so I've done some more research... this file will open on everyone else's PC except mine without error. I have gone into Add/Remove programs and chosen to reinstall Office 2000. I've restarted, and I'm still getting the same error.

What else could be different with my PC specifically? Do I need to completely remove Office and reinstall?

 

[SkipVought]

Try Help > Detect & Repair.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[combo]

Password-protect vba project on the machine you can open the file. Can you open it now on your computer?
Check references and components used. If they are different from standard excel (excel, office, ole, msforms), can you yse them in brand new file on your machine?

combo