Results 1 to 6 of 6

Orphan Sheets in MS Excel Object folder

Threaded View

  1. 01-24-2012, 06:20 PM #1
    juanjoaliag
    juanjoaliag is offline
    Registered User
    Join Date
    01-24-2012
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    4

    Orphan Sheets in MS Excel Object folder

    Every now and then after creating and removing sheets with VBA code, there are orphan sheets that have no name and have the icon of "ThisWorkbook" object. When selecting them, you see the properties of "ThisWorkbook" object.

    They are not in the Sheets() object and I can't erase them.

    I attache a pic of what I see. Sheets from 13 to 18 and 20... they are unaccessible from code. I want to delete them.

    OrphanSheets.jpg
    Last edited by juanjoaliag; 01-24-2012 at 06:31 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1