asked on 9/7/2010

Run-time error '57121': Application-defined or object-defined error

I have an Excel file that people in the company access one at a time (the file is NOT set to "Share Workbook.")

And after some VBA and file structure changes, this error is sporadically occurring after they click enable macros.

After this error appears, I see that a control button I've inserted is deleted, none of the VBA code will run (although the code exists in the editor), and all data validation drop down lists are wiped out!

I cannot duplicate this error on my PC, but it is happening, seemingly sporadically, across computers. It's happened 4 times today and I need to constantly restore the file.

I need help, and fast!

Thanks

Microsoft Excel

Last Comment

HaimD

9/8/2010

Missus Miss_Sellaneus

9/7/2010

This may be worth a try:
http://www.mrexcel.com/forum/showthread.php?t=55245

HaimD

9/7/2010

ASKER

Not a practical solution...thanks though

Norie

9/8/2010

HaimD

I think we need quite a bit more information - this could be happening for a no of reasons.

At least you seem to have eliminated one possibility - shared workbook restrictions.

Can you choose to debug when you get the error?

If so what piece of code is highlighted?

ASKER CERTIFIED SOLUTION

HaimD

9/8/2010

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial