In 2007, click the Office button (the big Circle button), choose "Excel
Options", "Trust Center", "Trust Center Settings", "Macro Settings", "Trust
access to the VBA project object model".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"JNW" wrote in message
...
I don't know if this is still the case with xl2007, but in 2003 they
created
a new security catch. If you go to Tools Macros Security then to the
Trusted Publishers tab there is a check box that says "Trust access to
Visual
Basic Project". This is generally the culprit if you have already set the
security level to the settings you have.

I don't have xl2007 yet, and have seen little of the ribbon setup. So, I
don't know how to even get to the macro security settings, but hopefully
this
will help.

--
JNW


"pglufkin" wrote:

I am getting a message when I try to run a macro within my program . .
"Because of your security settings, macros have been disabled. To run
macro,
you need to reopen this workbook, and then choose to enable macros".

The only problem is, I have the most liberal macro settings possible
within
the trust center. I have enabled all macros in the Macro Settings and I
have
enabled all controls without restrictions under the ActiveX Settings.

I'm running Excel 2007

What am I missing?
--
paul