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 x2 Windows 10 Enterprise x64, 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
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
What is Macro / Script ?
I heard a lot about Macro and Scripts , something about automating task, file management, directory management, disk drive management etc. So how can any user use that to his efficiency, like file and directory management is one thing i could associate with the prospect of learning Macro or...
General Discussion
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
outlook macro's - how
is there anyway to copy macro's from word to outlook 2010, tried and got an error. the type of macro that i'm talking abput are to switch different font's with a mouse click, size's or set sentences - words that have to be repeated many times (on many different days, so copy clips will not really...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office

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