| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell lock does not work ?!
Hello, I have a worksheet wich I protect fully. Some cells are defined as unlocked, wich aree available to enter date. Now I have some cells (not all) wich, however they are protected/locked, still behave as a unlocked cell. So, I can accidently still overwrite cells with formulas. I've been looking throughout the forum but cannot find a solution .... does anyone have an idea what this could be ? Or give me a hint where to look ? Regards, Hunter -- huntermcg ------------------------------------------------------------------------ huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391 View this thread: http://www.excelforum.com/showthread...hreadid=510276 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
Ron will get back to you! <vbg
tools|Protection|allow users to edit ranges (after you turn worksheet protection off) huntermcg wrote: Hello, I have a worksheet wich I protect fully. Some cells are defined as unlocked, wich aree available to enter date. Now I have some cells (not all) wich, however they are protected/locked, still behave as a unlocked cell. So, I can accidently still overwrite cells with formulas. I've been looking throughout the forum but cannot find a solution .... does anyone have an idea what this could be ? Or give me a hint where to look ? Regards, Hunter -- huntermcg ------------------------------------------------------------------------ huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391 View this thread: http://www.excelforum.com/showthread...hreadid=510276 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
After setting the cell property to locked, are you sure the worksheet is then
protected? "huntermcg" wrote: Hello, I have a worksheet wich I protect fully. Some cells are defined as unlocked, wich aree available to enter date. Now I have some cells (not all) wich, however they are protected/locked, still behave as a unlocked cell. So, I can accidently still overwrite cells with formulas. I've been looking throughout the forum but cannot find a solution .... does anyone have an idea what this could be ? Or give me a hint where to look ? Regards, Hunter -- huntermcg ------------------------------------------------------------------------ huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391 View this thread: http://www.excelforum.com/showthread...hreadid=510276 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
Ron, can you please explain more what you can do with that function .. I do not understand where your aiming at. Jennifer, I protect the worksheet after the cell is locked. But that is how I do it all the time and it seems to work fine. Now I experience problems with particular cells. I have a rather big worksheet. -- huntermcg ------------------------------------------------------------------------ huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391 View this thread: http://www.excelforum.com/showthread...hreadid=510276 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
Ron, can you please explain more what you can do with that function .. I do not understand where your aiming at. Jennifer, I protect the worksheet after the cell is locked. But that is how I do it all the time and it seems to work fine. Now I experience problems with particular cells. I have a rather big worksheet. -- huntermcg ------------------------------------------------------------------------ huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391 View this thread: http://www.excelforum.com/showthread...hreadid=510276 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
I'm not Ron, but you can allow users to edit ranges on a protected worksheet.
And in this case (Map2.xls???), that option was set without using a password. huntermcg wrote: Ron, can you please explain more what you can do with that function .. I do not understand where your aiming at. Jennifer, I protect the worksheet after the cell is locked. But that is how I do it all the time and it seems to work fine. Now I experience problems with particular cells. I have a rather big worksheet. -- huntermcg ------------------------------------------------------------------------ huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391 View this thread: http://www.excelforum.com/showthread...hreadid=510276 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
Hi Dave, I have the same problem with the cells: locked but possible to edit. Checked everything (also passwords as you said). It's still possible to edit the cells  I think it has to do with something that overrules the security of these cells. But what... I hope you have an idea. -- Patrick Betman ------------------------------------------------------------------------ Patrick Betman's Profile: http://www.excelforum.com/member.php...o&userid=31334 View this thread: http://www.excelforum.com/showthread...hreadid=510276 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
Unprotect the worksheet.
Then check under Tools|Protection|allow users to edit ranges If you find anything in that list that isn't password protected, either remove it or give it a nice password (depending on what you want.) Patrick Betman wrote: Hi Dave, I have the same problem with the cells: locked but possible to edit. Checked everything (also passwords as you said). It's still possible to edit the cells I think it has to do with something that overrules the security of these cells. But what... I hope you have an idea. -- Patrick Betman ------------------------------------------------------------------------ Patrick Betman's Profile: http://www.excelforum.com/member.php...o&userid=31334 View this thread: http://www.excelforum.com/showthread...hreadid=510276 -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lock does not work ?!
It works. The cells were "hidden" in an enormous list of ranges.... Thank you for the tip!! Patrick Betman:) Dave Peterson Wrote: Unprotect the worksheet. Then check under Tools|Protection|allow users to edit ranges If you find anything in that list that isn't password protected, either remove it or give it a nice password (depending on what you want.) Patrick Betman wrote: Hi Dave, I have the same problem with the cells: locked but possible to edit. Checked everything (also passwords as you said). It's still possible to edit the cells I think it has to do with something that overrules the security of these cells. But what... I hope you have an idea. -- Patrick Betman ------------------------------------------------------------------------ Patrick Betman's Profile: http://www.excelforum.com/member.php...o&userid=31334 View this thread: http://www.excelforum.com/showthread...hreadid=510276 -- Dave Peterson -- Patrick Betman ------------------------------------------------------------------------ Patrick Betman's Profile: http://www.excelforum.com/member.php...o&userid=31334 View this thread: http://www.excelforum.com/showthread...hreadid=510276 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Data Validation does not work when selecting another cell. | Excel Discussion (Misc queries) | |||
| Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
