View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default hiding formulas and defined names in a worksheet

JE gave the URL to get the code.

Here is for the addin

http://www.straxx.com/excel/password.html

--
Regards,
Tom Ogilvy

"alldreams" wrote in message
...
please send me the URL.

thanks
-----Original Message-----
Code is posted here about twice a week to remove

worksheet protection. I
can give you a URL where you can download a free addin

to do it.

--
Regards,
Tom Ogilvy

"alldreams" wrote

in message
...
how is it easy to break? examples?

-----Original Message-----
In defined names, you can hide them. for cells, you

can
check the hidden
and locked properties and then protect the worksheet.

Password protection on sheets is pretty easy to break
however.

--
Regards,
Tom Ogilvy

"alldreams"

wrote
in message
...
Is there a way to password protect formulas in cells
and
Defined Names?

Thanks for your help

Johann


.



.