[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3538
  • Last Modified:

Run-time error 57121 in Excel 2010 but not in 2007 on Sheets("xxx").Select commands

I have an Excel workbook that has VB command buttons that simply execute a Sheets("XXX").select command that works perfect in Excel 2007.

The problem is with the few users that have upgraded to Excel 2010 that click that command button and get the following error:

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

I looked online but wasn't abel to find a solution to this specific scenerio.

Any help would greatlly be appreciated.
0
itcaptain
Asked:
itcaptain
  • 3
  • 3
1 Solution
 
hitsdoshi1Commented:
Button has to be form control button not the active X control button.....if you are using activeX control button - that's what creates the problem. Try using form button and it should work.
0
 
itcaptainAuthor Commented:
I tried making it a "Form Control" button and not an activeX button and got the same error.

I noticed when I run the file off my local hard disk it works fine.  When running it from the network I have the error.  I ensured the document is a "trusted" document and even the network locaiton I added to my trusted locations.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
itcaptainAuthor Commented:
I ended up restoring a from a backup of a known working copy and it seems to be working in both 2007 and 2010.  I will close this thread as no solution was ever produced that fixed this exact issue.
0
 
itcaptainAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for itcaptain's comment http:/Q_27030052.html#35881932

for the following reason:

No one proposed a solution that fixed this issue and therefore went to a previous backup of a known working copy rather than spend more time fixing something that seemed unfixable.
0
 
hitsdoshi1Commented:
Possible solution was provided and it didn't worked for you that doesn't mean there were no efforts made to provider solution.

Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now