Can't lock cells
in [General]
|
From: BruceM via OfficeKB.com on 5 May 2010 15:38 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
From: Gord Dibben on 5 May 2010 19:31 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(a)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.
From: BruceM via OfficeKB.com on 6 May 2010 07:42 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
From: bala_vb on 6 May 2010 03:05 BruceM via OfficeKB.com;951508 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. > > -- > Message posted via http://www.officekb.com Try this, Goto Tools->Protection->Protect Sheet (instead of protect workbook) All the best -- bala_vb
From: Gord Dibben on 6 May 2010 18:12 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(a)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.
|
Pages: 1 Prev: Online Help Next: Excel 2007 Crashes when Saving to .xls |