Question on Macros in 2007
 

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

Question on Macros in 2007
 

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?

Question on Macros in 2007
 

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?

Question on Macros in 2007
 

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?

Question on Macros in 2007
 

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.