activating Macro in Excel 2007

sdharmarajan · #1 Mar 14, 2008, 08:54 AM

When transferred my files from an old computer with Excel 2003 to Vista based PC with Excel 2007, the old macros do not work. Please help me to activate the macros. Thanks

Sdharmarajan

JBeaucaire · Mar 14, 2008, 09:40 AM

Did you choose to allow the macro FUNCTIONs in Excel overall? Even in Office 2003 macros won't run unless you had instructed Excel to either 1) run them automatically or 2) Ask to enable macros when opening the document.

In 2003 that setting is in under TOOLS > MACRO > SECURITY

Choosing HIGH or VERY HIGH security would disable most macros automatically. Check it out.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!