VBA Project Deletion

Question

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?

Answer 1

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.

Answer 2

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.

Answer 3

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.

Answer 4

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.

Answer 5

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