Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
real bug - defined names & copying worksheet | Excel Discussion (Misc queries) | |||
Defined Names in Formulas when copying Worksheets in a Workbook | Excel Discussion (Misc queries) | |||
Defined Range Names in formulas | Excel Discussion (Misc queries) | |||
Worksheet Names is Defined by Cell value on Sheet 1 (named Summary | Excel Discussion (Misc queries) | |||
save worksheet as another file, but have all defined names copied | Excel Discussion (Misc queries) |