Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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?


.



.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 576
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Object Error 91 Bob Barnes Excel Discussion (Misc queries) 7 June 29th 09 06:24 PM
Object Variable Not Set Error on Selection object Jean Excel Worksheet Functions 3 July 24th 06 06:45 PM
VB Error Object Library Not Registered Karine Rivet Excel Discussion (Misc queries) 2 April 11th 06 07:13 PM
How do I get rid of the error "can't shift object off sheet" MStuck Excel Discussion (Misc queries) 1 April 29th 05 10:39 PM
error! Not a valid embedded object Shadina Excel Discussion (Misc queries) 0 January 4th 05 12:53 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"