Error Msg: Permission to use object denied

[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?

 

[A. Nguyen]

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.

 

[Tom Ogilvy]

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]

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.

 

[steve]

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