I have written a VB application in Excel and it is being distributed to many users. However, many users are getting a 'Can't find project or library' error and after some research I believe the references are the cause.

Ideally, I'd like to add code that inserts references (mainly the Visual Basic for Applications and a handful of Object Libraries)...then distribute the updated version. Is this possible?

Failing that I would direct each user to add the necessary references onto their computer directly. However, I was talking with one user and it seems that the 'References' option is greyed out under 'Tools' in the VB editor. This must mean they have no libraries installed, which is what I was thinking. However, the 'Browse' button is under 'References' (which is grey), so how might I instruct them to go about this method?