Can I save a macro in a template?

[David]

I'm trying to save a macro in a template, but when I re-
open the template the macro has gone.
What gives?
Sorry, I'm new to Excel. Is this a no-no, or am I doing
something wrong.

- David

 

[Bob Kilmer]

You should be able to save a macro in a template in the same way as any
workbook. Make sure you are getting the macro into the correct workbook (the
one you intend to save as a template). Save workbook as Template. Open a new
workbook based on the template. The code should be there.

(If still not working, what version of Excel? What operating system
version?)