I'm having trouble getting a distributed macro to work on a few
machines. The macro fails on the first line which reads:

Worksheet(1).Activate

I've also tried using the Sheets collection, but still the same error.

The computers in question run the following versions of excel:

Excel 2000 (9.0.6926 SP-3)
Excel 2000 (9.0.3821 SR-1)
Excel 2000 (9.0.2720)

I thought it might be a versioning issue (I developed the macro in Excel
2002), but one other instance of Excel 2000 (9.0.6926 SP-3) runs the
macro fine.

Does anyone know if something would block the Activate method in Excel?
The worksheet in question is actually a tab-delimited file that is
opened with excel.

Chris Bloom