Share via

VBA Project Deletion

Anonymous
2021-02-04T20:59:44+00:00

I am trying to delete VBA projects with in the developer tab, but the option to remove them is greyed out. I wish to delete it and have a fresh start. Please advise?

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2021-02-04T21:03:28+00:00

    The easiest way is to save the workbook as a .xlsx workbook. Excel will display a warning that all macro content will be lost. That is what you want.

    Close and reopen the workbook, then add code, and save the workbook as a macro-enabled workbook (.xlsm) again.

    3 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2021-02-05T20:17:14+00:00

    Hi Charren,

    Hans provided instructions for removing all macros from a workbook.

    Do you want to pick and choose which items to delete? You do that within the Project explorer in the Visual Basic Editor.

    You can't delete a Project in the Explorer. Open workbooks are the names of the projects. Closing a workbook will remove its project name from the Project Explorer.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-02-08T20:32:38+00:00

    The issue was the add ins under option on a PC and Tools on a Mac. I had to disable the “Solver add in” and the VBA projects that I wanted to delete disappeared.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2021-02-09T18:25:21+00:00

    I have OCD so looking at them when I follow tutorials makes me distracted. I just can’t stand to see all these projects. They were haunting me lol

    0 comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2021-02-09T18:14:55+00:00

    Hi

    That makes perfect sense. Add-ins are Excel workbooks that start up when you open Excel. Each add-in appears as an entry in the Projects list.

    I am curious as to why it concerns you to see these in the list.

    0 comments