+ Reply to Thread
Results 1 to 1 of 1

Second "ThisWorkbook" module in a vba project

  1. 06-17-2021, 01:15 AM #1
    ValentinaVL
    ValentinaVL is offline
    Registered User
    Join Date
    06-17-2021
    Location
    Volgograd
    MS-Off Ver
    365
    Posts
    1

    Second "ThisWorkbook" module in a vba project

    Hi.
    In some of my Excel files (old ones) there appears a second Sheet called "ThisWorkbook", it is seen in the screenshot I attach. This Sheet cannot be deleted. And if I apply to it some vba instructions (Feuil48.Name, for example), it gives error Automation error -2147418113 (8000ffff). If anyone has seen the same,do you have any solution except exporting everything in a new virgin Excel file ?
    Attached Images Attached Images
    Last edited by ValentinaVL; 06-17-2021 at 01:16 AM. Reason: misprint
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How can I add "If ActiveSheet.Name = "Sheet2" Then" to the following code in a module ?
    By omega0010 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2014, 11:57 PM
  2. Need to run "sheet 1" Marco first then automatically run "Module 1" afterwards?
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2014, 08:20 PM
  3. TO KNOW THE PROJECT STATUS IF "ONTIME" OR "DELAY" - as attached sheet
    By javaidmr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2014, 07:39 PM
  4. Create copy of current workbook using vba which has the code in the "thisworkbook" module
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-15-2012, 01:22 PM
  5. How to call a procedure from a different module, witihin "ThisWorkbook"
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-08-2012, 09:59 AM
  6. Excel 2003 "Compile error in hidden module: ThisWorkbook"
    By JeffBrown in forum Excel General
    Replies: 1
    Last Post: 11-05-2007, 04:02 PM
  7. Sheet turns into a "ThisWorkbook" module
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1