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
tia

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
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 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

Kevin
My System SpecsSystem Spec
.

Reply

 enabling macros in Excel




Thread Tools




Similar help and support threads
Thread Forum
Forum for question on Macros in Excel ?
Hello, I am having problems creating a macro in Excel. The keystrokes are not recorded as I expect. Can you advise on the correct section or forum where I should submit my question? Many thanks, Ken
Microsoft Office
Excel 2010 continues to put macros in old user profile XLSTART
I am rebuilding my Win 7 in a new user profile and am now trying to get my macros into the new user profile XLSTART. Every time I create a test macro to see were Excel will place it, it ends up in the old user profile XLSTART. (My old user profile was corrupted by disk problems that have been fixed...
Microsoft Office
Excel 2010 Macros Will Not Run On A New Machine
Am running Win7 and Office 2010. Several years ago I wrote four macros to perform operations in Excel 2010. Thet we to be placed in Personal.XLS so they would be available on all worksheets. I put links to them in the Quick Access bar. Twice I have tried to use those macros on different...
Microsoft Office
Excel 2003 Macros do not run correctly on a Windows 7 system.
Hi all, I've got a series of Excel 2003 spreadsheets with macros. They run just fine on a Windows XP machine. However, we recently moved them to a Windows 7 Pro machine. We still run them in Excel 2003, only now on a Windows 7 system. Problem is, they don't run right. No errors, but the one...
Microsoft Office
Excel Macros Disabled Under W7
Last week, I received a new notebook with Win 7 professional as OS - :o New to me and I feel way behind time noting the posting dates on the forum. Then there is reference to W8 :shock: I have been developing a program in Excel since 1995, improving the macros and output worksheets as I go along....
Microsoft Office
Running old Excel macros in Windows 7
I have quite a few macros written in older versions of excel that now won't run on our Windows 7 machines. Getting the error that the library is not found. I assume this is an issue with the new "Library" function in Windows 7. Does anyone know what to do to run these? From what I have found,...
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 20:13.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App