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

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" wrote in message
...
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.