You want to keep the formulas hidden from the user, but allow them to
protect/unprotect the worksheet whenever they want???

I don't think you can do that using builtin features.

But you could replace your worksheet formulas with UserDefined Functions
(rewrite them in VBA) and then the user can see your function and you'll still
have some secrecy:

=myTopsecretformula(a1,b1,c1)

wouldn't mean much to me.

On the other hand, the really interested could buy a password cracker that will
unprotect your code and then they could see it.

Dag Johansen wrote:

Hi,

is it possible to use protection at the Range level rather
than the Sheet?

I would like a module to lock a cell and hide it's
formula, but at the same time the end user should be able
to protect the sheet/book using a password of her own
choice. Can it be done?

Hope for a positive answer! Meanwhile, happy coding.

Dag Johansen

--

Dave Peterson