If you can see the VBA code for the workbook, then there is no further password you should need to set or remove a reference (though you can't remove a reference in use). Sounds like a corrupt workbook to me, which is the ultimate fate of all shared workbooks.