uac crashes excel macro

M

madmax2

New member
Hi,

I am having a problem when I try to run an excel macro addin (ie vba functions) that calculates some statistics, it doesn't work. Shows permission denied.


When I turn off UAC, It works.

Is there any fix for this?
Turn UAC on and off is too annoying...cos u need to reboot each time.
 

My Computer

OS
Microsoft Windows 7 Ultimate 64-bit 7601 Multiprocessor Free Service Pack 1
CPU
Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz
Motherboard
ASUSTeK Computer INC. P8Z68-V PRO
Memory
16.00 GB
Graphics Card(s)
AMD Radeon HD 6950
Sound Card
(1) AMD High Definition Audio Device (2) Webcam 250 (3)
Screen Resolution
1920 x 1080 x 32 bits (4294967296 colors) @ 60 Hz
Hard Drives
(1) M4-CT064M4SSD2 ATA Device (2) M4-CT128M4SSD2 ATA Device (3) SAMSUNG HD103SJ ATA Device (4) WDC WD20EARX-00PASB0 ATA Device (5) WDC WD20EARX-00PASB0 ATA Device (6) WDC WD20 EARS-00MVWB0 SCSI Disk Device (7) Generic USB CF Reader USB De
PSU
Corsair HX 650
First thing I would do is to check the access permissions on the folder containing the macro - It could simply be a case that the macro is located in a folder that requires elevated rights to access - this is the case with anything in the Program Folders Tree.

If you give the actual user full rights to either the folder or the file It may cure the issue.

It may of course be something else depending on the actual macro code but this is worth an initial investigation :)
 

My Computers

System One System Two

  • Computer type
    PC/Desktop
    Computer Manufacturer/Model Number
    ChillBlast - Custom to my design
    OS
    Windows 11 Pro x64 [Latest Release and Release Preview]
    CPU
    Ryzen 9 5950X, 3.8 - 5.2 MHz
    Motherboard
    Asus Prime X570-Pro
    Memory
    64GB [2 x 32GB] DDR4 3200MHz
    Graphics Card(s)
    4GB NVIDIA GEFORCE GTX 1650 Ti
    Sound Card
    On-board SPDIF to 5.1 System + HDMI [5.1 system]
    Monitor(s) Displays
    32" UHD 32 Bit HDR Monitor + 43" UHD 4K 32Bit HDR TV
    Screen Resolution
    2 x 3840 x 2160 @60Hz
    Hard Drives
    1TB M2 SSD OS, 500GB Fast Access SSD, 2 x 8TB Data + Various Externals from 1TB to 4TB, 10TB NAS
    PSU
    NZXT C750 80 PLUS Gold 750W Modular PSU
    Case
    Workstation Case [Matt Black]
    Cooling
    NZXT Kraken X63 280mm CPU Cooler +2x Quiet Case fans
    Keyboard
    Logitech Wireless MX Keys & K400 + others
    Mouse
    Logitech Wireless MX Master 3S
    Internet Speed
    920 MB Down 50 MB Up
    Antivirus
    BitDefender Total Security Pro
    Browser
    Chrome (always run latest Non-Beta)
    Other Info
    Also run ...
    Laptop - Quad 8GB - Windows 10 Pro x64
    Nexus 7 Android tablet x2
    Samsung 10.2" tablet
    Blackview TAB 8 4G Android Tablet c/w Keyboard
    Wacom Intuos Pro Medium Pen Pad
    Wacom Intuos Pro Small Pen Pad
    Wacom Expresskeys Remote
    Loopdeck+ Graphics Controller
    Shuttle Pro v2 Control
  • Computer type
    Laptop
    System Manufacturer/Model Number
    Dell XPS 17 10750H
    OS
    Windows 11 Pro x64 Latest RP
    CPU
    Intel I7 10750H 5.0GHz
    Motherboard
    Dell XPS
    Memory
    32GB [2x16GB] DDR4 2933 MHz
    Graphics Card(s)
    nVidia GTX1650Ti 4 GB GDDR6
    Sound Card
    Stock [Realtek] 4 Speaker
    Monitor(s) Displays
    17" IPS UHD+ Infinity Edge Touchscreen
    Screen Resolution
    3840 x 2400
    Hard Drives
    2TB M2 NVMe, 4TB External + various 500GB & 1TB External NVMe (also have access to spinner HDD from
    PSU
    Stock
    Case
    Stock XPS Aluminium & Carbon Fibre
    Cooling
    Stock - Active Fan Control
    Keyboard
    Backlit + Various Logitech
    Mouse
    Stock Track Pad + Logitech MX Trackball
    Internet Speed
    72 MB Down 18MB Up
    Browser
    Chrome
    Other Info
    Also run ...
    Laptop - Quad 8GB - Windows 10 Pro x64
    Nexus 7 Android tablet x2
    10.2" tablet
    Sony Z3 Android Smartphone
    Wacom Intuos Pro Medium Pen Pad
    Wacom Intuos Pro Small Pen Pad
    Wacom Expresskeys Remote
    Loopdeck+ Graphics Controller
    Shuttle Pro v2 Control Pad
    10TB NAS
it's a .xla excel addin, which I installed via office 2003 addin option..

so I guess it would copy it to the addin folder in office..

with it's default priviledges

I can send you the addin and you can test it out..
if you figure a solution it would be good.
 

My Computer

OS
Microsoft Windows 7 Ultimate 64-bit 7601 Multiprocessor Free Service Pack 1
CPU
Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz
Motherboard
ASUSTeK Computer INC. P8Z68-V PRO
Memory
16.00 GB
Graphics Card(s)
AMD Radeon HD 6950
Sound Card
(1) AMD High Definition Audio Device (2) Webcam 250 (3)
Screen Resolution
1920 x 1080 x 32 bits (4294967296 colors) @ 60 Hz
Hard Drives
(1) M4-CT064M4SSD2 ATA Device (2) M4-CT128M4SSD2 ATA Device (3) SAMSUNG HD103SJ ATA Device (4) WDC WD20EARX-00PASB0 ATA Device (5) WDC WD20EARX-00PASB0 ATA Device (6) WDC WD20 EARS-00MVWB0 SCSI Disk Device (7) Generic USB CF Reader USB De
PSU
Corsair HX 650
You must log in or register to reply here.
Back
Top