Creating a new addin - Best Practice

[Gale T]

Hi,

I have to combine the functionality of two Excel addins into a single addin. Is it common practice to do the development in XLSM format and then save it in XLA fromat when it's am done or do everything in xla format? My first impulse is to use xlsm until I am done because I often save backup versions until I complete what I am doing and I don't want to mess with multiple addin versions.

Gale

 

[Jerry Sullivan]

Hi Gale and Welcome to MrExcel,

I usually start out using .xlsm format then convert the add-in to .xlam. Sometimes I'll use worksheets in the add-in and in those cases, it's necessary to have the workbook unhidden to setup those sheets.

I also find that when I'm editing an .xlam file, I'm more likely to accidently close Excel without saving the last changes, whereas that rarely happens in a visible .xlsm workbook.

 

[Gale T]

Hi Jerry,

I didn't think of the issue of forgetting to save the .xlam file. This is exactly what I needed, thank you very much. I will follow your example.

Gale