I have quite a complex VB Excel file with many macros and Forms.
All works great on my PC, but when the file is opened from another users PC it immediately comes up
with a Copile error. Cannot find Library etc.

The VB line highlighed is :
Sheet1.Range("C16").Value = Format(Now, "mmmm yy")
With the [Format] Highlighted.

If i click OK, and try to run a macro i then get another Compile error.

Is there a way to fix this?
Both PC's re running Office XP and have ALL Excel components installed.

Corey....