Hi

Quick question - can Excel Templates contain macros?

Thanks

A

Quick answer: Yes.
--
Regards!
Stefi



€žAlex Hammerstein€� ezt Ã*rta:

Hi

Quick question - can Excel Templates contain macros?

Thanks

A

.

Yes.

But I'm not sure if I would. When those macros need updating (and they always
do!), it'll be difficult/impossible to find all the existing workbooks that have
been created from that template (or copies of the workbooks based on that template).

I'd consider creating an addin that contained the code (a single addin) and
sharing that with the users who need the macros.



On 05/19/2010 02:37, Alex Hammerstein wrote:
Hi

Quick question - can Excel Templates contain macros?

Thanks

A

Yes, if you are using excel 2003, you can directly write the code .xls file

if you are using excel 2007, .xlsm support macros whereas .xlsx doesnt support macros.

in both cases make sure that macro security setting is low/trusted.

all the best