MS Excel - File Links - VBA
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.