I have a excel spreadsheet that I want only myself to be able to edit and view hyperlinks, I can not work out a way other than password protecting the sheet, I don't want to have to keep putting a password in.
You want the best of both worlds without doing any thing...Not possible.
Not matter what protection you give to your work book it can be broken very quickly, Excel was NOT designed for multi users and its protection is full of holes.