 | |
| |
| 25 Sep 2012 | #1 |
| | 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 Specs | |
| 25 Sep 2012 | #2 |
| | 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 Specs |
| 26 Sep 2012 | #3 |
| | 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 Specs |
| . |
| |
 |
enabling macros in Excel problems?
« PowerPoint 2010: Play video with external player on "Next Slide"?
|
cloned old drive to SSD, now microsoft office says "not activated" »
| Thread Tools | |
| Similar help and support threads for: enabling macros in Excel | ||||
| Thread | Forum | |||
 Excel 2010 Macros Will Not Run On A New Machine | Microsoft Office | |||
| How do I set keyboard macros? | Customization | |||
| 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 | |||
All times are GMT -5. The time now is 12:19 AM.
