I am in the process of creating a ms excel application that links to another ms excel workbook.

Using ms office 2003, the worksheet that contains the links is protected.
Thus far I have written some vba that unprotects the worksheet, but, I need some help with the code that enables the user to change the file links by using the Edit>Links dialogue and then once the changes have been made, i.e. they have changed the linked source, protects the worksheet contents again.

I am working on a very similar project. Anyone has any idea? Barnsley, were you able to solve it? If any one can share any idea or code, would be much appreciated. Thanks.