Personal MAcro Save

[jakobt]

I copy a macro to a module in my personal macro workbook.

Is there a way to save that change immediately, without having to either open the personal macro book and saving it or save all open workbooks and wait for the question want to save your macro personal book.

For some reason I often make change in my personal macro book. And then when I close all open excel books - I might forget to change saves. (Because I forgot I actually did changes in it).

 

[Joe4]

I do not know of any way to do an automatic save based on changes to VBA code. All the automated events I know of are workbook or worksheet related. I do not think any "VBA automated events" exist.

I just make it a habit to always do a save immediately after updating my Personal Workbook Macros.

 

[Fluff]

Not sure if I'm missing something here, but why not just click the save icon in the vb editor?