Windows 7: uac crashes excel macro

madmax2 · 18 Oct 2009

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.

Barman58 · 18 Oct 2009

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

madmax2 · 19 Oct 2009

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.

Windows 7: uac crashes excel macro

uac crashes excel macro problems?