Can't see References from toolbar

H

HockeyFan

I've got a user (at a remote location) having trouble with an
application that I wrote in VBA within Excel.
It runs on some machines, but not all. I've determined that it's
missing some dll because of the error popup that says it's missing a
project or library.

So I asked the user to view references. They tell me that they go to
Tools within VBE, but that the References option is greyed out. What
would cause this?
 
P

Perry

It runs on some machines, but not all.
Tools within VBE, but that the References option is greyed out. What
would cause this?
Click to expand...

The differences between the machines where your code is working and those
where your code fails.
If you synchronise the differences, your problem will be solved.

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE
 
C

Chris Jakeman

I've got a user (at a remote location) having trouble with an
application that I wrote in VBA within Excel.
It runs on some machines, but not all. I've determined that it's
missing some dll because of the error popup that says it's missing a
project or library.

So I asked the user to view references. They tell me that they go to
Tools within VBE, but that the References option is greyed out. What
would cause this?
Click to expand...

It could be that your user is executing VBA code at the time that he
views. This disables the References... option.

Hope that helps, Chris

Bye for now,

Chris Jakeman
Peterborough, UK
 
Top