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

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?

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?

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?

Solution would be same. I do not remember the navigation.

Can get back to you in about 10 hours as I do not have access to 2007 right
now.