+ Reply to Thread
Results 1 to 5 of 5

Object not found error

  1. #1
    Registered User
    Join Date
    10-21-2011
    Location
    Peterborough, UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Object not found error

    I have spent a long while creating a spreadsheet which shows different options depending on selections made.... I now have a problem when sending it to someone else:

    Please Login or Register  to view this content.
    When I run this on my comp it works fine, but after sending it to someone to do a test complete, they get the error message:

    Run-time Error '-2147024809 (80070057)':

    The Item with the specified name wasn't found - Debug points to the Me.Shapes line of code.

    Any help appreciated!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object not found error

    That would suggest that the shape either is not there, or has a different name on their system.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    10-21-2011
    Location
    Peterborough, UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Object not found error

    But how, if I have defined the shape as "Group1" when designing the sheet? This is going to happen all through the workbook as different options are supposed to appear

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object not found error

    Are you both using the same version of Excel?

  5. #5
    Registered User
    Join Date
    10-21-2011
    Location
    Peterborough, UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Object not found error

    Oddly enough we are both using 2010 - written in and used in.... but when I change it to a 97-2003 worksheet it runs fine!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1