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

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

18 Oct 2009   #2

Windows 7 Ultimate x64 x2 + x86 + Windows 8.1 x64 x2
 
 

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
.


Reply

 uac crashes excel macro




Thread Tools



Similar help and support threads for2: uac crashes excel macro
Thread Forum
Solved Excel 2013 crashes after opening and using any xls/xlsx file Microsoft Office
Excel Macro Microsoft Office
Excel 2010 crashes (BSOD) when opening a file BSOD Help and Support
EXCEL VBA Macro Sort Groups of Items Microsoft Office
EXCEL VBA 2007 Macro: Offsetting cell form a user defined selection Microsoft Office
Excel 2003 Macro Help? Microsoft Office
Can't open 2003 Excel Files in Excel 2007? 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 05:58 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33