Hello Excel Forum members,

First and foremost, I am using Excel 2010 (sort of against my will) but I do have two computers on the network that require access to my excel creations and who are using Excel 2007 (the problems caused by this have only been minor). Also, I'm completely new to this forum (as an active participant) and I'm not really sure where I was meant to post this. If there is a more appropriate place for this then please let me know, or perhaps a moderator can move this for me? And down to business...

"Protecting cells whilst allowing hyperlinks to be used"

This is something that has been bugging me for a long, long time now. I've developed a lot of different Excel systems and solutions for my office of non-computer literate colleagues and a major problem from the start has been them clicking on hyperlinks 'incorrectly' which causes them to panic because they see letters and '=' and brackets, and they end up breaking things. Surely there must be a nice, simple (hmm, in excel?) solution that locks editing but allows use of hyperlinks.

On a different, though not unrelated note, I'm also after finding out how to protect the format of an entire page and yet still allow people values, perhaps even copy and paste values to different cells, though I fear that this might only be possible in a perfect world...

I look forward to your responses and being able to post some of the more interesting problem that I am trying to find solutions to at the minute.

Many thanks,

Ben