"Permission to use object denied"

[ssVBAdev]

Good Morning!

I have an Excel file (developed in 2000) which works fine on 98 machines which run XL 2000.

I have a new error that has poped up on another machine (in another office location) that are having trouble.

In that office, they have, and are, using the file without problems - except for this one computer that they have loaded the file onto and are trying to use the file.

When they double click the file to open it the following message box appears:

"Permission to use object denied" the box is titled "Microsoft Visual Basic", has a "critical" logo and "Okay" and "Help" buttons.

Does anyone know what this message is reffering to? I think it may be an erlier version of excel but I am verifying this right now.

Any thoughts would be appreciated.

Thanks.

********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!

 

[SQLBI]

Hi,

What does the help file say when you click the Help button on the MsgBox?


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[ssVBAdev]

Well, as I said, it's on a computer in another office. So, I can't check first hand although I have thought of that and am trying to reach them to have them check it out and let me know.

I'm trying a few things at one time and this forum was one of those things. I was just wondering if anyone has encountered this message before and what it meant in their perticual senario.

********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!

 

[ssVBAdev]

Hopefully I can get some responses to this one. I need to blow the dust off it first...

The error goes something like:

Permission to use object denied (Error 419)
You don't have the necessary permisions for the specified object. This error has the following cause and solution:
- You currently don't have the authority to access this object.
To change you persmission arguments, see your system administrator or the objects creator.

Now... here's the rub. As far as I am told, this persons machine has all the access of a regular administrator for that machine (perhaps this needs to be verified).

And, as I may have stated, the .xls file works on all the other machines in this office and they are setup similarly.

As for the "object" in question. How on earth would I be able to know what the object is? I've got so many references, modules, forms etc... Could it simply be that they are denied access to one of the Windows .dll files that is required by the references?

Argh... ...Frustrating.

********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!

 

[ssVBAdev]

I, again need to bump this up to the fore front. The answer still evades me. It's tough not being able to actually sit down at the machine in question, but based on the info at hand, I cannot find any helpfull info anywhere. Any other thoughts... ???

********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!

 

[PHV]

Just a thought: what is the macro security level ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[ssVBAdev]

Interesting thought... I would have to find that out. But, if the macro security is a problem, it seems to me that the macro warning would show prior to there being any problems or conflicts with permissions associated with any objects (assuming, perhaps, that is is an object within the VBA that is causing the problem).

I shall check on the macro security level though...

********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!