Error 57121

[kstws810]

I've searched and found no answers for this problem. I have seen this problem before on the msg board.

I get Run-time-error 57121 when opening Excel file, when setting the scrollarea.

Private Sub Workbook_Open()
'Set scroll area
Sheets("Records").ScrollArea = "$A$1:$AE$70"
End Sub

I made the file in Excel2007 and sent out to other person to fill in some data. Before sending out all was ok and no errors.
When file received back I get the error when opening.
Sheets is still there. Any ref to the sheet I get an error as if the sheets has been deleted.

What can be the problem? Can it be the Excel version the other person used to fill in the sheet?


rgds

 

[Derek Brown]

Hello and welcome to The Board.
I cannot see anything wrong with the code and it works OK for me.
Have a look at the following post:
http://www.mrexcel.com/forum/showthread.php?t=55245
Perhaps the same solution may help.

 

[kstws810]

Thanks.

Before the code was working. But now any reference to this one sheet does not work anymore. Had a look at the link but the 'Wait' is not the answer.

Think it is the button I created on the sheet. During file conversion, to earlier Excel version, this corrupts the original code reference.
On the vba tools reference there are no missing links.

I think I have to change the ActiveX control Button on the sheet to a Form control to keep the file working.

Does this makes sense?