I just sent out budget files that have external links in them. Most tabs are protected
But people cannot edit the links on one file to link it to another file. The file linked has a password on the file also. How can I allow users to edit the links? Do I have to unprotect the file before Links can be edited?
Code:
WSheet.Protect Password:="XXX", DrawingObjects:=False, Contents:=True, Scenarios:=True, AllowFiltering:=TrueBut people cannot edit the links on one file to link it to another file. The file linked has a password on the file also. How can I allow users to edit the links? Do I have to unprotect the file before Links can be edited?
