+ Reply to Thread
Results 1 to 4 of 4

VBAProject - Microsoft Excel Objects

  1. #1
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    932

    VBAProject - Microsoft Excel Objects

    Hi,

    I have Copysheet1, Copysheet2, and Copysheet3 listed but they are not worksheets.

    I would like to remove but I cannot.

    Does anyone know how to remove these please?

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: VBAProject - Microsoft Excel Objects

    Hi there,



    Saving the workbook with a ".xlsx" extension will remove the unwanted modules.

    After doing this you must then import the CodeModules from your original workbook and then save the modified workbook with a ".xlsm" extension.

    Hope this helps.

    Regards,

    Greg M

  3. #3
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    932

    Re: VBAProject - Microsoft Excel Objects

    Yes that helped thanks!

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: VBAProject - Microsoft Excel Objects

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

+ 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. Microsoft Excel Objects Folder has ghost sheets that I cannot remove
    By ramridge in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-15-2020, 07:57 PM
  2. shrink or Hide Microsoft Excel Objects
    By rr1050 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2020, 10:57 AM
  3. [SOLVED] Microsoft Excel Objects (two different worksheet types)
    By TomSteude in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-05-2017, 09:17 AM
  4. Microsoft Excel Objects (two different worksheet types)
    By TomSteude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2017, 08:11 AM
  5. How do you delete Microsoft Excel Sheet Objects???
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2014, 11:20 AM
  6. Ms. Office 2013, Microsoft PowerPoint Object Library (References-VBAProject)
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2014, 09:44 AM
  7. How to remove empty microsoft excel object of vbaproject
    By namrata2143 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2014, 07:12 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