problem with macro setting

[reza]

hi all,

i have a problem every time i open file with existing macro there an error:
"Because of your security settings, macros have been disabled. To run
macros, you need to reopen this workbook, and then choose to enable macros"
i use excel 2007.
i already change my setting in Trust Center Settings and choose Enable all
macros (not recommended,....) but still failed.

If i create a new one than create new module, the macro will run but if i
save and close then reopen, i can't run that file...

what wrong with me?

many thanks

reza

 

[Jacob Skaria]

Review the below
http://office.microsoft.com/en-us/excel/hp100969191033.aspx