Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default password protect cells problem

Could be.

I'd unprotect the worksheet and make sure the cells I want locked are locked and
the cells I want unlocked are unlocked.

Tools|Protection|unprotect sheet
select the range to lock
format|cells|protection tab|check locked.

Select the range to unlock and do the similar thing.

Then reprotect the worksheet and test it.

oxicottin wrote:

I have an excel sheet that I password protected certain cells so data could
be entered. I reciently incerted a few cells and went back threw and
reselected the cells that I wanted password protected. Well the new cell I
just incerted I wanted writeable and they are not but everything else is just
fine. Could it be because I I inserted the cell next to one that was
protected before? How do I fix this?

Thanks!!


--

Dave Peterson
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default password protect cells problem

I have done this.. and it still seems to want to protect the cells that I
inserted. The cells that I inserted were next to an originally protected cell
if that means anything..

Thanks

"Dave Peterson" wrote:

Could be.

I'd unprotect the worksheet and make sure the cells I want locked are locked and
the cells I want unlocked are unlocked.

Tools|Protection|unprotect sheet
select the range to lock
format|cells|protection tab|check locked.

Select the range to unlock and do the similar thing.

Then reprotect the worksheet and test it.

oxicottin wrote:

I have an excel sheet that I password protected certain cells so data could
be entered. I reciently incerted a few cells and went back threw and
reselected the cells that I wanted password protected. Well the new cell I
just incerted I wanted writeable and they are not but everything else is just
fine. Could it be because I I inserted the cell next to one that was
protected before? How do I fix this?

Thanks!!


--

Dave Peterson

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default password protect cells problem

I found the problem. I think because I inserted from a prior protected cell
it autmaticaly locked each of those cells because the prior row was completly
locked. Thats all I did was unlocked each sell I wanted to be able to type
into. Thanks for your reply!!!

"oxicottin" wrote:

I have done this.. and it still seems to want to protect the cells that I
inserted. The cells that I inserted were next to an originally protected cell
if that means anything..

Thanks

"Dave Peterson" wrote:

Could be.

I'd unprotect the worksheet and make sure the cells I want locked are locked and
the cells I want unlocked are unlocked.

Tools|Protection|unprotect sheet
select the range to lock
format|cells|protection tab|check locked.

Select the range to unlock and do the similar thing.

Then reprotect the worksheet and test it.

oxicottin wrote:

I have an excel sheet that I password protected certain cells so data could
be entered. I reciently incerted a few cells and went back threw and
reselected the cells that I wanted password protected. Well the new cell I
just incerted I wanted writeable and they are not but everything else is just
fine. Could it be because I I inserted the cell next to one that was
protected before? How do I fix this?

Thanks!!


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating only non-empty cells... Jay Excel Worksheet Functions 9 September 22nd 06 03:20 AM
Validate MsgBox Entry to Data in Cells David Excel Discussion (Misc queries) 13 December 21st 05 10:31 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM
password protected certain cells in spreadsheet vv Excel Discussion (Misc queries) 2 February 9th 05 10:46 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"