moving macros to disc.

[Postma]

The excel 2000 spread sheet I have has several macros.
The problem comes when I save the sheet to a disk it will
not open and run.

These messages come up;
Could not register visual basic environment - Run Setup
error initualizing VBA library 1157.

What can I do to get this sheet to run off a disc.

 

[Henry]

Postma,

XL doesn't like being run from floppy disk.
Copy the file to the destination hard drive and run it from there.

HTH
Henry