... After I protected my worksheet, some cells can be changed... Dr. Darrell 24.02.2006 21:49:30 I applied some protection i a worksheet and most of the cells work propoerly. I can enter data where I want to, I'm restricted from entering data in some cells, my formulas can't be changed except in two columns of cells. I have two columns of cells that have a simple formula, =$N$2 , besides that the cells are formated for percentages. I can click into any of the cells in these two columns and type anythin I want. Is there an issue with protection when using =$N$2 or percentages. Darrell

Re: ... After I protected my worksheet, some cells can be changed... Dave Peterson <petersod[ at ]verizonXSPAM.net> 24.02.2006 23:59:07 I double check the worksheet protection and the lockedness of the cell. Unprotect the worksheet select the cell format|cells|protection tab Make sure Locked is checked. Then reprotect the worksheet. (Locked cells don't really do anything until the worksheet is protected.) Dr. Darrell wrote: [Quoted Text] > > I applied some protection i a worksheet and most of the cells work propoerly. > I can enter data where I want to, I'm restricted from entering data in some > cells, my formulas can't be changed except in two columns of cells. > > I have two columns of cells that have a simple formula, =$N$2 , > besides that the cells are formated for percentages. I can click into any of > the cells in these two columns and type anythin I want. > > Is there an issue with protection when using =$N$2 or percentages. > > Darrell -- Dave Peterson

Re: ... After I protected my worksheet, some cells can be changed. Dr. Darrell 25.02.2006 12:10:26 Dave: Thank you. I thought I had done that, but somehow I had overlooked those two columns. Darrell "Dave Peterson" wrote: [Quoted Text] > I double check the worksheet protection and the lockedness of the cell. > > Unprotect the worksheet > select the cell > format|cells|protection tab > > Make sure Locked is checked. > > Then reprotect the worksheet. > > (Locked cells don't really do anything until the worksheet is protected.) > > Dr. Darrell wrote: > > > > I applied some protection i a worksheet and most of the cells work propoerly. > > I can enter data where I want to, I'm restricted from entering data in some > > cells, my formulas can't be changed except in two columns of cells. > > > > I have two columns of cells that have a simple formula, =$N$2 , > > besides that the cells are formated for percentages. I can click into any of > > the cells in these two columns and type anythin I want. > > > > Is there an issue with protection when using =$N$2 or percentages. > > > > Darrell > > -- > > Dave Peterson >

Re: ... After I protected my worksheet, some cells can be changed. Dave Peterson <petersod[ at ]verizonXSPAM.net> 25.02.2006 14:23:00 I hate when that stuff happens, too! Dr. Darrell wrote: [Quoted Text] > > Dave: > > Thank you. I thought I had done that, but somehow I had overlooked those two > columns. > > Darrell > > "Dave Peterson" wrote: > > > I double check the worksheet protection and the lockedness of the cell. > > > > Unprotect the worksheet > > select the cell > > format|cells|protection tab > > > > Make sure Locked is checked. > > > > Then reprotect the worksheet. > > > > (Locked cells don't really do anything until the worksheet is protected.) > > > > Dr. Darrell wrote: > > > > > > I applied some protection i a worksheet and most of the cells work propoerly. > > > I can enter data where I want to, I'm restricted from entering data in some > > > cells, my formulas can't be changed except in two columns of cells. > > > > > > I have two columns of cells that have a simple formula, =$N$2 , > > > besides that the cells are formated for percentages. I can click into any of > > > the cells in these two columns and type anythin I want. > > > > > > Is there an issue with protection when using =$N$2 or percentages. > > > > > > Darrell > > > > -- > > > > Dave Peterson > > -- Dave Peterson