Solved

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

Posted on 2010-09-07
4
6,535 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:HaimD
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Missus Miss_Sellaneus
ID: 33622180
0
 

Author Comment

by:HaimD
ID: 33622536
Not a practical solution...thanks though
0
 
LVL 33

Expert Comment

by:Norie
ID: 33629777
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?
0
 

Accepted Solution

by:
HaimD earned 0 total points
ID: 33631608
This error was being caused by a Control Toolbox Button.  I switched it to a Form Button, and I now longer get this particular error.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question