On top of these recommendations, the OP should be aware that worksheet
protection isn't made to protect intellectual property. It's made to help
prevent the user from making typing errors--like overwriting cells with
important formulas.


baldmosher wrote:

"Dave Peterson" wrote:

Nothing built into excel.
But you could create a macro:

I've done this to good effect.

But if you do this, make sure you name your macro something not very
obvious, in case the recipient simply runs your "unlock" macro to unlock the
sheets!

Also you should password protect your macro project to prevent people
discovering your password within the code.

--

Dave Peterson