Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: enabling macros in Excel

25 Sep 2012   #1

windows 7, 64
enabling macros in Excel

to enable macros in Excel I have to go to Developer then enable macro.
Err message ordering me to exit the file, then re-enter it and repeat the "enabling" procedure. This does not always remedy the problem. I have to restart the computer... then go back to my Excel worksheet.

However, now even this doesn't work! Result: I am unable to use my macros.

My System SpecsSystem Spec
25 Sep 2012   #2

Microsoft Community Contributor Award Recipient

Windows 7 SP1, Home Premium, 64-bit

I use a couple of macros but have never had a similar problem.

Are your macros in a "trusted location"?

Have you considered a repair install of Excel?

Have you considered a System Restore to a date before this trouble began?

I can't recall using "enable micro" in the Developer tab and don't even see that choice right now.
My System SpecsSystem Spec
26 Sep 2012   #3
Kevin Ismail

Windows 7 Ultimate x64

I assume you're having at least MS Office 2007 SP2 or later MS Office.
There should be no problem if save it as Macro-enabled workbook (.xlsm).
Yes you have to go to Option -> trust center -> trust center setting -> macro setting -> enable....
You can also add your file location as trusted location

My System SpecsSystem Spec

 enabling macros in Excel

Thread Tools

Similar help and support threads for2: enabling macros in Excel
Thread Forum
Macros Language Support Microsoft Office
Solved Excel 2010 Macros Will Not Run On A New Machine Microsoft Office
Can I Create Macros on Windows 7 General Discussion
Excel 2003 Macros do not run correctly on a Windows 7 system. Microsoft Office
Excel Macros Disabled Under W7 Microsoft Office
Running old Excel macros in Windows 7 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:52 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App