Re: "Index was out of range" error

A couple of things to check:
Could be related to security.  Is something in the sheet trying to access something your user doesn't have access to?
Could be related to macro security.  Have the user login to the sheet on your machine and see if you get the same error.  If you do, it rules out something specific to  user's machine/excel.