Hi Vicky

Office Buttonexcel Options
Trust Center..Trust center settings
Macro settings

Or use the shortcut Alt tms

If your workbook is protected it is also possible that this is your problem
http://www.rondebruin.nl/password2007.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vicky" wrote in message ...
what about in 2007?

"Sheeloo" wrote:

This is because of security.

You can make the desired changes under Tools-Macro-Security in Excel 2003.


"Vicky" wrote:

I saved files as Macro enabled, but every time I open the
file the Macros are disabled. Why is this happening?