I Have a protected workbook which has some external links, I need to Reassign them locally (Remove external workbook reference) but keep Sheet and Cell References are still correct. The workbook was passed on to me, the guy who wrote it he Forgot the password, Its frustrating when a co worker locks a workbook, hides sheets then forgets the password. Is this possible with VBA.