Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock cells
I have a spreadsheet in which I have locked certain cells, then I protected
the spreadsheet (Tools Protection Protect Worksheet). However, I can still write to the locked cells. I can prevent that by not allowing users to select locked cells, but I would like them to be able to copy and paste. What am I missing? I am using Access 2003. -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock cells
If you can still edit locked cells then you have not protected the worksheet
properly. Or the cells you think are locked are not. Gord Dibben MS Excel MVP On Wed, 05 May 2010 19:38:24 GMT, "BruceM via OfficeKB.com" <u54429@uwe wrote: I have a spreadsheet in which I have locked certain cells, then I protected the spreadsheet (Tools Protection Protect Worksheet). However, I can still write to the locked cells. I can prevent that by not allowing users to select locked cells, but I would like them to be able to copy and paste. What am I missing? I am using Access 2003. |
#3
|
|||
|
|||
Quote:
Goto Tools-Protection-Protect Sheet (instead of protect workbook) All the best
__________________
Thanks Bala |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock cells
I thought I had provided enough detail to show I had locked the cells and
protected the worksheet properly. However, there is a layer of protection I had not considered. It was an inherited workbook, and it turns out that ranges were unlocked (Tools Protection Allow User to Edit Ranges. Presumably this option is intended to allow certain users to edit ranges, but instead they had implemented it without requiring a password, which was effectively the same as unlocking the cells. All cells were locked (Format Cells Protection), but ranges were exempted behind the scenes. Gord Dibben wrote: If you can still edit locked cells then you have not protected the worksheet properly. Or the cells you think are locked are not. Gord Dibben MS Excel MVP I have a spreadsheet in which I have locked certain cells, then I protected the spreadsheet (Tools Protection Protect Worksheet). However, I can still write to the locked cells. I can prevent that by not allowing users to select locked cells, but I would like them to be able to copy and paste. What am I missing? I am using Access 2003. -- Message posted via http://www.officekb.com |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock cells
Thanks for letting us know Bruce.
One thing I never thought of. I never use the "allow users to edit ranges" Gord On Thu, 06 May 2010 11:42:23 GMT, "BruceM via OfficeKB.com" <u54429@uwe wrote: I thought I had provided enough detail to show I had locked the cells and protected the worksheet properly. However, there is a layer of protection I had not considered. It was an inherited workbook, and it turns out that ranges were unlocked (Tools Protection Allow User to Edit Ranges. Presumably this option is intended to allow certain users to edit ranges, but instead they had implemented it without requiring a password, which was effectively the same as unlocking the cells. All cells were locked (Format Cells Protection), but ranges were exempted behind the scenes. Gord Dibben wrote: If you can still edit locked cells then you have not protected the worksheet properly. Or the cells you think are locked are not. Gord Dibben MS Excel MVP I have a spreadsheet in which I have locked certain cells, then I protected the spreadsheet (Tools Protection Protect Worksheet). However, I can still write to the locked cells. I can prevent that by not allowing users to select locked cells, but I would like them to be able to copy and paste. What am I missing? I am using Access 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock cells | Excel Discussion (Misc queries) | |||
lock cells | Excel Worksheet Functions | |||
Lock all cells? | Excel Discussion (Misc queries) | |||
How do I lock all cells in a given row together to one another? | Excel Discussion (Misc queries) | |||
Lock Cells | Excel Discussion (Misc queries) |