+ Reply to Thread
Results 1 to 2 of 2

Extra sheetnames and a workbook have appeared in my list of modules,sheets and workbooks

  1. #1
    Forum Contributor
    Join Date
    02-01-2021
    Location
    Manchester
    MS-Off Ver
    365
    Posts
    216

    Extra sheetnames and a workbook have appeared in my list of modules,sheets and workbooks

    As I was working on an app, and for a reason I can't fathom, suddenly, my list of sheets, modules etc was nearly doubled. When I selected such a numbered sheet from this list all the new ones took on the name of the same existing sheet. There was no sign of any of these sheets being actually present in the work book. There was also listed a new workbook named workbook1. Unlike the new sheets this workbook did not respond to any left or right clicks.
    My question is 1). will it be safe to delete the unwanted sheet names? and 2.) how do I remove workbook1 as it does not respond to a key click.
    John

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Extra sheetnames and a workbook have appeared in my list of modules,sheets and workboo

    I would probably start rebuilding a clean copy of your workbook.
    Rory

+ 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. [SOLVED] Help to combine two Modules from seperate workbooks to one workbook preform task
    By tcrjmom in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-30-2014, 06:14 PM
  2. VBA for consolidate sheets into one workbook from list of workbooks.
    By sureshpunna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2013, 07:13 AM
  3. Search for a line in all Modules in a workbook and add extra line below
    By sans in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2013, 03:17 PM
  4. Replies: 4
    Last Post: 07-19-2009, 10:45 PM
  5. List all modules in workbook X?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2006, 02:30 PM
  6. Replies: 3
    Last Post: 04-17-2006, 09:15 AM
  7. [SOLVED] how to update Listbox of sheetnames if user changes sheetnames?
    By tr00per in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-12-2006, 04:10 AM

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