View Single Post
  #5   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

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



.