Since the calculate Event sub has no "Target" Parameter, the use of "Target" in the code is meaningless.
Change bothtoIf Target.Column = 5 And Target.Row = 17 And Target.Value =And Change the others to the similar. Range("E26")If Range("E17").Value =