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.
System Manufacturer/Model Number Ignatz Special; 4 speed manual gearbox; factory air conditioning; one of one OS Windows 7 SP1, Home Premium, 64-bit CPU Intel Sandy Bridge i5-2500, not overclocked Motherboard Gigabyte H67A-UD3H-B3, full ATX Memory 4 GB Crucial DDR3-1333 Graphics Card none; graphics are integrated on CPU Sound Card onboard: Realtek ALC892; external: USB Behringer UF0-202 Monitor(s) Displays NEC 90GX2-BK 19" LCD Screen Resolution 800 x 640
Keyboard Leopold Tenkeyless with Cherry Blue switches, USB Mouse Logitech or Microsoft optical wired; either USB or PS 2 PSU Seasonic SS-560KM, modular Case Antec Solo II Cooling CPU: Scythe Big Shuriken; Case: Scythe Slipstream 800 & 500 Hard Drives System: Intel 320 Series SSD, 80 GB;
Data: Samsung Spinpoint 103SJ, 1 TB;
Backup: WD Caviar Green WD15EADS-00P8B0, 1.5TB Other Info Power consumption of this system, including monitor: 68 watts at idle; 144 watts at full load
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
Computer type PC/Desktop System Manufacturer/Model Number Self built system OS Windows 7 Ultimate x64 CPU CORE i5 Motherboard Intel DH55PJ Memory 4GB Graphics Card ATI HD 4650 Sound Card Realtek HD Integrated Monitor(s) Displays LG Flatron L1742S; LG Flatron 19"; Toshiba 32" Screen Resolution 1280 x 1024; 1366 x 768
Keyboard Logitech Wireless Mouse Logitech Wireless PSU Power Case Simbadda Cooling Conventional Hard Drives Seagate Barracuda 500 GB
WDC 1 TB Internet Speed 256Kbps Other Info External HDD Transcend 500GB
Dial Up Modem Huawei
Home-made Home Theater
Laptop ASUS K42F, Core i3, 4GB memory, 320GB HDD.
LAptop Fujitsu LH531, Core i3, 4GB Memory, 500 GB HDD, Nvidia VGA