+ Reply to Thread
Results 1 to 4 of 4

Cloned worksheets and workbook

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    Poland
    MS-Off Ver
    Office 365 - ver 2016
    Posts
    2

    Cloned worksheets and workbook

    Hello everyone

    I'm new in the forum, but I have been reading it already couple years I think. While working on improving my old project I run on weird error. After two years of working with this file all of the worksheets and workbooks got cloned in weird way which is showed only in VBA editor. I cannot delete them, cannot view them, but they cause series of errors in all of the VBA code (including Automation Error). Obvious precautions were made, and worked up till recent days. Screenshots of the issue below (Sorry for Polish language inside of it):
    Worksheet.JPG
    Workbook.JPG

    I cannot attache file itself because of all the fragile data that is in it. If it's needed let me know what other data I can provide.

    Cheers
    Adeophan

  2. #2
    Registered User
    Join Date
    09-19-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Cloned worksheets and workbook

    Hi Adeophan,
    How they got cloned might remain a mystery, or might be due to a recent mistaken addition or modification to your code in the wb somewhere... (I once added code intended for one ws in another, and when the other ws misbehaved I went crazy because "I had Not modified it.") :D
    but...
    Could they be hidden? Right click any ws tab and click Unhide...
    HTH
    Cheers

  3. #3
    Registered User
    Join Date
    03-29-2017
    Location
    Poland
    MS-Off Ver
    Office 365 - ver 2016
    Posts
    2

    Re: Cloned worksheets and workbook

    Hi Alphonse68,
    I tried to unhide them even before starting this thread. As you can see in VBA Editor, they have different icons so they are not standard ws or wb. At the same time I cannot use VBA to delete them, I receive ActiveX error saying that those names don't exist.
    The whole problem is that I didn't modify VBA on this file for like 6 months, only sheets inside changed, but this should not interfere with code due to all of it being used based on Sheet names not their positions. I'm 100% positive that user modification of one of the sheets caused this mess, but due to large amounts of data processed each day I cannot afford to revert it to the old version.

    To be honest I hoped that somebody already saw something like that and would manage to at least give me insight where to start.

    Cheers

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Exclamation

    Hi !

    Workbook is corrupted, damaged, …

    At least perform a Web search on this subject !
    Without any backup, just try to copy data to a brand new workbook …

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba code - hide the sheet after it is cloned
    By honger in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 12-11-2013, 12:31 PM
  2. Worksheets from source to replace worksheets in the destination workbook when closed
    By anushatamby in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2013, 03:52 PM
  3. Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets
    By NumberCruncher311 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2013, 08:21 PM
  4. Copying Data from WorkSheets and Pasting them to a different Worksheets/Workbook
    By JRayhan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 11:22 AM
  5. [SOLVED] Copying Worksheets from Multiple Workbooks to a Single Workbook, Separate Worksheets
    By DHartwig35805 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-27-2012, 11:38 AM
  6. Copying Worksheets from Multiple Workbooks to a Single Workbook, Separate Worksheets
    By Abhi_1977 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2012, 11:32 AM
  7. Adding rows when cells are cloned/mirrored?
    By kmuirhead in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-31-2011, 06:01 AM
  8. [SOLVED] ADO cloned recordset doesn't return field names
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2005, 06:06 PM

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