Linking between sheets

[nitind]

I have created a sheet "Checklist" which contains link to named ranges within other sheets.When I click on links on this sheet named "checklist" then it takes me to the specified ranges in other sheets.All the sheets are protected and they too contain a link "back" which takes back to the sheet "checklist".Now when I click anywhere on the sheets (other than the "checklist") it goes back to the checklist sheet even if I have not clicked the "back" link....??
Why?? Can u suggest a solution

 

[Richard Schollar]

Perhaps try allowing your users to select locked cells in your protection options.