View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
A. Nguyen A. Nguyen is offline
external usenet poster
 
Posts: 3
Default 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?


.



.