Error Msg: Permission to use object denied

  • Thread starter Thread starter A. Nguyen
  • Start date Start date
A

A. Nguyen

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?
 
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.
 
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
 
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.
 
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
 
Back
Top