Saving Workbook as an AddIn

[HighAndWilder]

Hi All

I'm just exploring using Add-In's to slowly build up a Function Library.

Do please tell me if this is not the right way to go but the idea I have is to save the macro enabled workbook as an Add-In when I close the workbook.

I have recorded a macro and notice that whilst code is recorded to save the workbook as a macro enabled workbook the code to save the workbook as an Add-In is missing. The ChDir line to change the folder to the default Add-In folder is there though.

Is there a valid reason why this is the case?

Is there a way around this problem if it is indeed a problem?

How do others manage Add-In's?

Thanks and I hope that you are all having a good day.

HighAndWild

 

[Dryver14]

My understanding is that addins are best used for things like major projects where you may need to maintain code for a group without having to go to every pc or recalling workbooks.

The thing you are trying to do is probably best kept in a functions module in your personal workbook.

 

[RoryA]

Why do you need to use code to save the workbook as an add-in? Even if you do, just add a line to do that.