hiding formulas and defined names in a worksheet
 

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

Thanks for your help

Johann

hiding formulas and defined names in a worksheet
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

Thanks for your help

Johann

hiding formulas and defined names in a worksheet
 

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

hiding formulas and defined names in a worksheet
 

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


.

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


.

hiding formulas and defined names in a worksheet
 

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


.



.

hiding formulas and defined names in a worksheet
 

Check out

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

In article ,
"alldreams" wrote:

how is it easy to break? examples?

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


.



.