enable macros in 2007



hi, please help. i'm new to excel 2007. i designed a template in excel 2003
that uses 12 macros. my problem is that i seem to be unable to turn the macro
enabled feature of excel 2007 on. i have changed all the trust centre
settings on all 5 computers on our network to "allow all macros" as well as
"trust access to VBA projects", i have changed the save option to save files
as format "macro enabled workbooks", yet every time we save a file (with one
of the macros) it says "the following features cannot be saved in macro-free
work books * VB project". what am i doing wrong, i'm really frustrated, so
would appriciate any advice. thanks



Ron de Bruin

See if this helps

Run Office Diagnostics.
Office Button>Excel Options...Resources

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question