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.

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

If this post helps click Yes
--------------
Jacob Skaria


"Tigerxxx" wrote:

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.

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

"Jacob Skaria" wrote:

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

If this post helps click Yes
--------------
Jacob Skaria


"Tigerxxx" wrote:

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.