Home

VBA best practice

%3CLINGO-SUB%20id%3D%22lingo-sub-645014%22%20slang%3D%22en-US%22%3EVBA%20best%20practice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-645014%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20design%20a%20multi%20Excel-workbook%20VBA%20project.%20I%20want%20it%20to%20be%20menu%20driven.%20My%20question%20is%2C%20what%20is%20best%20practice%2C%20should%20I%20have%20one%20workbook%20as%20an%20%22xlsm%22%20and%20the%20rest%20as%20%22xlsx%22%3F%20As%20far%20as%20I%20am%20aware%20the%20VBA%20macro%20is%20associated%20with%20the%20%22xlsm%22%20workbook.%20Is%20that%20correct%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-645014%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-645060%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20best%20practice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-645060%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F348397%22%20target%3D%22_blank%22%3E%40Obiwan_Kenobi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20would%20do%20it%20this%20way.%20macros%20to%20the%20xlsm%20file%2C%20rest%20to%20xlsx.%3C%2FP%3E%3CP%3Eregards%3C%2FP%3E%3CP%3EBernd%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-645828%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20best%20practice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-645828%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347933%22%20target%3D%22_blank%22%3E%40Berndvbatanker%3C%2FA%3E%26nbsp%3BThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Obiwan_Kenobi
New 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

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies