Runtime error 57121

Question

Hi! Guys!

Has anyone come up with the solution regarding this error?? Please help this is really disgusting. An Excel file has been running so well for years since 2002 now is generating this error after upgrading from Excel 2003 to 2007. I tried installing 2010 and 2013 but still I get same problem. Please help.

The error pops out its ugly head on the below line of code:

 With Application.Thisworkbook.Worksheets("General Stock")

    .Activate

    .EnableSelection = xlNoSelection

    .Protect Password:="StringPassword"

End With

The error pops out its ugly head on .Activate function of the worksheet.

Answer 1

Hi! OssieMac,

I just upgraded from windows 7 to windows 8, I re-installed office 2013 and KABOOM!!! To my surprise, all my Excel files are up running perfectly well and just as they had normally and usually been running.

Wow!!

Warm regards,

S. T. S.

Woooohooooo!!!!!

Answer 2

OssieMac,

Thanks a lot for your prompt reply. Yeah it is kind of weird getting errors poping out on common Excel Worksheet functions. I checked actually on References but there is none that is showing as a missing reference. I actually did that before I went googling around. I also get errors on functions like:

    Worksheet.EnableSelection

    Worksheet.Protect Password:=myPassword

These are functions that you do not have to select any references, they automatically appear with Excel.

Anyway thanks a lot for your help I really appreciate so much. I'll just try some work arounds and see if I could get through.

Regards,

STS.

Answer 3

Code works fine for me in Excel 2010.

I don't know if the following will help but worth a look because you have upgraded the Excel version.

In the VBA editor Select menu item Tools -> References.

Check that you do not have any missing references. (It will show "MISSING REFERENCE" at the beginning of the reference name.)

If any missing references then uncheck the box against them and then scroll down and find the equivalent reference and check the box against it.

Missing References causes errors that one would not expect. eg I had one only yesterday that failed with Trim function and I would not have thought that the missing reference had anything to do with it.