Hard Code DLL Reference in VBA
 

Hi,

I've created a dll progress bar (in VB6) that i successfully use from excel 2003 VBA. The way i use it is that i have to reference it from tools-- references, etc.

I am providing this application to a number of users. As it would be a 'hasle' to go around to each and every user to reference the dll is there any way to 'hard code' the reference??

I 've copied the dll on the network and tried to reference it from there but it still does not work i have to go each and every time to re-reference it for a new user

any advice much appreciated,
regards,
Alex