complie error
 

I have an old macro (12/96). I've upgraded the spreedsheet that uses it and
now it only runs on the computer used to upgrade it. It has to run on other
computers. I get complie error: can't find project or library. The debuger
is pointing to CurDir(). I went back and looked at the old spreadsheet and
under tools there is a refenence menu option, with the new spreedsheet it's
grayed out. I think the problem is the vba library is not getting loaded.
How can I fix this error.

Thank for any help
Brian...

complie error
 

Hit the reset button, then the reference button shouldn't be grayed out.
Then you can go in and fix the references.

--
Regards,
Tom Ogilvy

"brian" wrote in message
...
I have an old macro (12/96). I've upgraded the spreedsheet that uses it
and
now it only runs on the computer used to upgrade it. It has to run on
other
computers. I get complie error: can't find project or library. The
debuger
is pointing to CurDir(). I went back and looked at the old spreadsheet
and
under tools there is a refenence menu option, with the new spreedsheet
it's
grayed out. I think the problem is the vba library is not getting loaded.
How can I fix this error.

Thank for any help
Brian...

complie error
 

thank you Tom

Brian...

"Tom Ogilvy" wrote:

Hit the reset button, then the reference button shouldn't be grayed out.
Then you can go in and fix the references.

--
Regards,
Tom Ogilvy

"brian" wrote in message
...
I have an old macro (12/96). I've upgraded the spreedsheet that uses it
and
now it only runs on the computer used to upgrade it. It has to run on
other
computers. I get complie error: can't find project or library. The
debuger
is pointing to CurDir(). I went back and looked at the old spreadsheet
and
under tools there is a refenence menu option, with the new spreedsheet
it's
grayed out. I think the problem is the vba library is not getting loaded.
How can I fix this error.

Thank for any help
Brian...