ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error Msg: Permission to use object denied (https://www.excelbanter.com/excel-programming/271556-error-msg-permission-use-object-denied.html)

A. Nguyen

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?

A. Nguyen

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?



.


Tom Ogilvy

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?



.




A. Nguyen

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?


.



.


steve

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?


.



.





All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com