enable macros in 2007

D

des-sa

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
 
R

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

Similar Threads

Macro help 2
Excel 2007 - Slow & can't run macros 9
Excel 2007 Enabling Macros 3
Enable Macros 1
ENABLE MACROS 2
Excel files - macros & links 4
Enable macros in 2007 5
Macros_programming & running 2

Top