hiding formulas and defined names in a worksheet

[alldreams]

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

Thanks for your help

Johann

 

[Frank Kabel]

Hi Johann
- goto 'Tools - Protection'
- protect your worksheet and workbook

 

[Tom Ogilvy]

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.

 

[alldreams]

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




.

 

[Tom Ogilvy]

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.

 

[alldreams]

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




.

 

[JE McGimpsey]

Check out

http://www.mcgimpsey.com/excel/removepwords.html

 

[Tom Ogilvy]

JE gave the URL to get the code.

Here is for the addin

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