How do i save code changes to an Excel VBA add-in?

Question

I've made an add-in for Excel in VBA and now I need to make changes to the code, but the file won't save. I open the .xlam file, I make the changes, ctrl-S to save with no errors popping up, close down. But when I reopen, none of the change I made are there. What gives? is there some special way I have to save an add-in to make changes stick?

Answer 1

I've had issues with add-ins not saving when the default Excel save is made; instead, you should make sure that you always save from inside the VBA editor. Beyond that, make sure you haven't checked the "Lock project for viewing" checkbox or added a password -- these can both be found on the "Protection" tab of the "Project Properties" dialog, the 5th item in the "tools" menu.

Answer 2

I have had occurrences where it did not look like the Add-In was saved. I had to unload the Add-In, restart Excel, and then reload the Add-In. The saved changes were there, just not shown until the Add-In was reloaded.

Answer 3

In the VB editor, select the project in the Project Explorer pane, then in the Immediate Window enter this line and press Enter:

ThisWorkbook.Save