Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    Blue Mountains, New South Wales, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Workbook VBA project stays in memory after the workbook is closed

    Using Windows 7 and Excel 2010

    When I close an Excel workbook, the workbook and modules are still listed in the VBA project explorer.
    If I open the same workbook twice, the modules are listed TWICE in the VBA project explorer.

    I cannot see a command to remove it, so need to exit and restart Excel.

    Is there a way to remove the project without restarting Excel????

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,534
    Thanks
    3
    Thanked 147 Times in 140 Posts
    I'm also using Windows 7 and Excel 2010.

    I don't see the same behaviour as what you describe so I'm guess there is an add-in that is causing your problem. What else is loaded? Can you disable them and test again?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,280
    Thanks
    46
    Thanked 250 Times in 230 Posts
    After doing some search regarding your symptoms, there are many who are experiencing the same problem with the work around of restarting excel to remove the duplicate VBA project. It seems that no one has specifically pinpointed a cause and/or a resolution, however, the majority of those with the problems have add-ons installed as Andrew implied. The most popular suggestion was to remove all the add-ons then reinstall one-by-one until the problem resurfaced thus identifying the culprit. However, there were those who had no add-ons installed who were experiencing the problem as well as those who had add-ons, removed them, and the problem never abated. This causative factor seems very vague with no definite solutions and Microsoft is not offering much help only occasionally referring to it as a bug.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •