Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Msg: Permission to use object denied
Users with only User Privileges are unable to open excel
files that require Power User or Administrator Privileges. Error Message is "Visual Basic: Permission to use object denied". This message points to error 419 but doesn't provide any workarounds or resolutions. This is Excel 97 running in a Windows 2000 environment. Is there any way to resolve this without granting normal users Administrator Privileges? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Msg: Permission to use object denied
Thanks for your reply. I've looked at the article and
cannot find anything files or folders listed there. I've ran a search for vbe*.* files and granted users modify access, and also searched for excel*.* and did the same thing. I still get the same error. Is there anything else you can think of? Thanks. -----Original Message----- http://support.microsoft.com/default.aspx?scid=kb;en- us;280829 OFF97: "Access Denied" Error Message When You Open a Document That Contains a Control although this is for NT, Windows 2000 is just a newer version of NT and didn't exist when Excel 97 was released - so I think this should be applicable. Regards, Tom Ogilvy A. Nguyen wrote in message ... Users with only User Privileges are unable to open excel files that require Power User or Administrator Privileges. Error Message is "Visual Basic: Permission to use object denied". This message points to error 419 but doesn't provide any workarounds or resolutions. This is Excel 97 running in a Windows 2000 environment. Is there any way to resolve this without granting normal users Administrator Privileges? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Msg: Permission to use object denied
the directory for these is created as a subdirectory off the users temp
directory. There are two subdirectories created Excel8.0 vbe Both contain .Exd files for me. Regards, Tom Ogilvy A. Nguyen wrote in message ... Thanks for your reply. I've looked at the article and cannot find anything files or folders listed there. I've ran a search for vbe*.* files and granted users modify access, and also searched for excel*.* and did the same thing. I still get the same error. Is there anything else you can think of? Thanks. -----Original Message----- http://support.microsoft.com/default.aspx?scid=kb;en- us;280829 OFF97: "Access Denied" Error Message When You Open a Document That Contains a Control although this is for NT, Windows 2000 is just a newer version of NT and didn't exist when Excel 97 was released - so I think this should be applicable. Regards, Tom Ogilvy A. Nguyen wrote in message ... Users with only User Privileges are unable to open excel files that require Power User or Administrator Privileges. Error Message is "Visual Basic: Permission to use object denied". This message points to error 419 but doesn't provide any workarounds or resolutions. This is Excel 97 running in a Windows 2000 environment. Is there any way to resolve this without granting normal users Administrator Privileges? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Msg: Permission to use object denied
Hi Tom,
You're absolutely right. Those 2 folders are created when you run Excel (as an admin) and record macros or create ActiveX controls. Copy those 2 folders over to the user's profile and that allows them to run it without Admin privileges. I hope this same method works for default profiles. Thank you so much for your time. -----Original Message----- the directory for these is created as a subdirectory off the users temp directory. There are two subdirectories created Excel8.0 vbe Both contain .Exd files for me. Regards, Tom Ogilvy A. Nguyen wrote in message ... Thanks for your reply. I've looked at the article and cannot find anything files or folders listed there. I've ran a search for vbe*.* files and granted users modify access, and also searched for excel*.* and did the same thing. I still get the same error. Is there anything else you can think of? Thanks. -----Original Message----- http://support.microsoft.com/default.aspx?scid=kb;en- us;280829 OFF97: "Access Denied" Error Message When You Open a Document That Contains a Control although this is for NT, Windows 2000 is just a newer version of NT and didn't exist when Excel 97 was released - so I think this should be applicable. Regards, Tom Ogilvy A. Nguyen wrote in message ... Users with only User Privileges are unable to open excel files that require Power User or Administrator Privileges. Error Message is "Visual Basic: Permission to use object denied". This message points to error 419 but doesn't provide any workarounds or resolutions. This is Excel 97 running in a Windows 2000 environment. Is there any way to resolve this without granting normal users Administrator Privileges? . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Msg: Permission to use object denied
Thanks to Tom,
Finally learned what those two folders in my Temp folder are all about. Now I'll stop deleting them when cleaning out my Temp folder... steve "A. Nguyen" wrote in message ... Hi Tom, You're absolutely right. Those 2 folders are created when you run Excel (as an admin) and record macros or create ActiveX controls. Copy those 2 folders over to the user's profile and that allows them to run it without Admin privileges. I hope this same method works for default profiles. Thank you so much for your time. -----Original Message----- the directory for these is created as a subdirectory off the users temp directory. There are two subdirectories created Excel8.0 vbe Both contain .Exd files for me. Regards, Tom Ogilvy A. Nguyen wrote in message ... Thanks for your reply. I've looked at the article and cannot find anything files or folders listed there. I've ran a search for vbe*.* files and granted users modify access, and also searched for excel*.* and did the same thing. I still get the same error. Is there anything else you can think of? Thanks. -----Original Message----- http://support.microsoft.com/default.aspx?scid=kb;en- us;280829 OFF97: "Access Denied" Error Message When You Open a Document That Contains a Control although this is for NT, Windows 2000 is just a newer version of NT and didn't exist when Excel 97 was released - so I think this should be applicable. Regards, Tom Ogilvy A. Nguyen wrote in message ... Users with only User Privileges are unable to open excel files that require Power User or Administrator Privileges. Error Message is "Visual Basic: Permission to use object denied". This message points to error 419 but doesn't provide any workarounds or resolutions. This is Excel 97 running in a Windows 2000 environment. Is there any way to resolve this without granting normal users Administrator Privileges? . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Object Error 91 | Excel Discussion (Misc queries) | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
VB Error Object Library Not Registered | Excel Discussion (Misc queries) | |||
How do I get rid of the error "can't shift object off sheet" | Excel Discussion (Misc queries) | |||
error! Not a valid embedded object | Excel Discussion (Misc queries) |