Question on Macros in 2007

[Vicky]

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

 

[Sheeloo]

This is because of security.

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

 

[Vicky]

what about in 2007?

This is because of security.

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

 

[Ron de Bruin]

Hi Vicky

Office Button>excel 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

 

[Sheeloo]

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.