In a spreadsheet with macros which runs perfectly on all computers I
tried it on (about three at work and two at home), I am getting a
Run-time error 1004 when it is opened by colleagues in India.

Any suggestions?