Log in

View Full Version : Activating Macro in Excel 2007


sdharmarajan
Mar 14, 2008, 09: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, 10: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.