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.4K 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-10T21:00:45+00:00

    Ah - Makes sense!

    Just remember to turn the add-ins back on when you want to use their functionality.

    0 comments