Compile Error:

I have a spreadsheet that is run by macros & buttons. It works perfect on the
computer that I created it on. When I download it to my other computer I
continually get "Compile error: - Can't find Project or Library".

It seems to be happening in Private Sub's in the Workbook on Open and
Activate.

I have no idea what is going on. Any help would be greatly appreciated.

Thank -you

Just a guess. Go to the Visual Basic editor and click on Tools, then References. Compare the selections between one PC and the other. My guess is that you are using some functions that are not selected in the second PC.

- Pete

Open the VB editor (alt F11) and go to Tools, References. Look for a missing
component in the list. That's almost certainly the problem.

Robin Hammond
www.enhanceddatasystems.com

"Ronbo" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet that is run by macros & buttons. It works perfect on
>the
> computer that I created it on. When I download it to my other computer I
> continually get "Compile error: - Can't find Project or Library".
>
> It seems to be happening in Private Sub's in the Workbook on Open and
> Activate.
>
> I have no idea what is going on. Any help would be greatly appreciated.
>
> Thank -you

"Ronbo" wrote:

> I have a spreadsheet that is run by macros & buttons. It works perfect on the
> computer that I created it on. When I download it to my other computer I
> continually get "Compile error: - Can't find Project or Library".
>
> It seems to be happening in Private Sub's in the Workbook on Open and
> Activate.
>
> I have no idea what is going on. Any help would be greatly appreciated.
>
> Thank -you


Thanks alot for your help. You are exactly right. I develop it using mscal
v9 and it would not work using mscal v8.