enabling macros in excel 2007 more versions

[aparunkumar]

I am now using Excel 2010. I have created an excel work book with macros and saved this as macro enabled work book. When this workbook is opened in my office by a colleague with excel 2007 the macro code such as print preview etc not worked even though we have enabled all macros in trustcenter settings. How to enable the same? If any code to enable all macros in such situations. Provide help.

[ImranBhatti]

When you open Excel 2007.The Security warning appears above the formula bar with a message
"Macros have been disabled" with a button named "Options..."
Click this button.
Microsoft Office Security Options dialogue box will appear
Click the radio button "Enable this content"
will enable the macros

[aparunkumar]

sir this option is not being displayed

[ImranBhatti]

Have you tried the bellow?

Click the office button at the top left (Excel 2007)
Go to Excel Options =>Click on Trust Center =>Trust Center Settings=Macro Settings
And Click the radio button "Enable all macros (Not recommended,potentially dangerous code can run") Click OK
Click OK

[aparunkumar]

sir this has already done. but enable content option willnot appear when re opening the file.