Can't Find Project or Library

[Kenji]

My excel sheet in Mac pops up a message saying

"Can't find project or library"

because I have a reference in VBA to a library that does not exist in the
Mac Excel.
I only use this library for PC Excel.

Is there a way to make the message not appear.. or stop excel from detecting
that the project or library is missing? I don't use it for the Mac version.
=(

Thanks for any help.

Kenji

 

[JE McGimpsey]

My excel sheet in Mac pops up a message saying

"Can't find project or library"

because I have a reference in VBA to a library that does not exist in the
Mac Excel.
I only use this library for PC Excel.

Is there a way to make the message not appear.. or stop excel from detecting
that the project or library is missing? I don't use it for the Mac version.
=(

You can use Conditional Compilation to split the Mac from the Windows
code:

#If Mac Then
'Exclusively Mac statements here
#Else
'Exclusively Win statements here
'load reference
#End if

For how to load a reference programatically, see

http://support.microsoft.com/default.aspx?scid=kb;en-us;213529