VBA best practice

Copper Contributor

I want to design a multi Excel-workbook VBA project. I want it to be menu driven. My question is, what is best practice, should I have one workbook as an "xlsm" and the rest as "xlsx"? As far as I am aware the VBA macro is associated with the "xlsm" workbook. Is that correct?

2 Replies

@Obiwan_Kenobi 

i would do it this way. macros to the xlsm file, rest to xlsx.

regards

Bernd

@Berndvbatanker Thank you