Macros_programming & running

[Tigerxxx]

I need to program a macro.

Whenever I try to paste the code under "Developer" - "Macros", it gives me
the error that macros are not enabled and that tI need to enable them.

I have already enabled the macros as follows:
Microsoft Office Button - Excel Options - Trust Center - Trust Center
Settings - Macro Settings - Enable all macros

However the next time I open the file it still does not allow me to program
the macros in Excel and gives me the error that macros are not enabled.
Am I missing something?
Please help.

 

[Jacob Skaria]

Set the Application security level to Low under Tools|Macro|Security which
will enable macros of all workbooks

If this post helps click Yes

 

[Tigerxxx]

Hi Jacob,

I have MS Excedl 2007 nad I do not see this option of "Tools/Macro/security".
Can you please tell me teh specific toolbars for Excel 2007 to use to
address this?

Thanks