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: uac crashes excel macro

18 Oct 2009   #1

Microsoft Windows 7 Ultimate 64-bit 7601 Multiprocessor Free Service Pack 1
uac crashes excel macro


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 System SpecsSystem Spec
18 Oct 2009   #2

Windows 10 Pro x64 x3, Ubuntu

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 System SpecsSystem Spec
19 Oct 2009   #3

Microsoft Windows 7 Ultimate 64-bit 7601 Multiprocessor Free Service Pack 1

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 System SpecsSystem Spec


 uac crashes excel macro

Thread Tools

Similar help and support threads
Thread Forum
Macro To Perform Redundant Excel Tasks
Hi, I am trying to extract information from one program, then import it into Excel. Well, the format it is extracted is not the format that is what I need. So, I have been manually deleting all the unneeded rows. My question is there a macro or C-Plus program that can delete these rows for...
Microsoft Office
Excel Macro to move columns to 1 row after each other.
I was hoping someone could help me write or find a macro that would take two columns and move it to column A under the previous data and repeat for all columns. Basically user information is located in pairs of columns (typeofvalue, value). So column A and B are for user1, column C and D are...
Microsoft Office
excel file crashes windows explorer
For some reason when I select one of my Excel 2013 spreadsheet files, right after my system boots the Windows Explorer crashes. I've ran virus scans and malware scans and found none. Any suggestions?
General Discussion
Excel 2013 crashes after opening and using any xls/xlsx file
Hi Members, when I open any XLS or XLSX file after few seconds or after doing any activity in any xls/xlsx file, Excel 2013 crashes (Office 2013 is updated to latest). There are no third party plugins enabled in Office 2013. ...
Microsoft Office
Excel 2010 crashes (BSOD) when opening a file
Hi Folks, I just changed out my President's XP-Pro to Win7 Pro 64 bit. We store all of our Word & Excel docs on a 6.5 Netware server. Yes it's old and out of date - but it cost money to change it. so..... I had no problems ever with XP but with Win7 when you open a Excel file it ...
BSOD Help and Support

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 03:14.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App