Search code examples
excelmacrosxlmexcel-4.0

Creating new xlm macros in excel 2007


Is it still possible to create (note create: not run) xlm macros in Excel 2007? I have an interest in historical languages (yes, I know xlm macros aren't going that far back in the grand scheme of things) and want to muck around with them.

I've searched the web and there's a million hits for how to enable support for legacy xlm macros, and that's all well and good. But I'm looking for info on how to create new ones. Would someone be able to point me in the right direction?


Solution

  • To create a macro sheet in XL2007 - Right-click a sheet tab, choose Insert and then Excel 4 Macro sheet.