Why not post the code there? There are some changes the user can make to their Excel that could make the code fail, assumptions about the default number of sheets etc. If you post the code we can take a look, there is no way of setting this:
something is preventing calling a subroutine in Sheet1 from a Module
So the issue must lay elsewhere