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.
LVL 1
itcaptainAsked:
Who is Participating?
 
itcaptainConnect With a Mentor Author 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
 
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.