LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 06:24 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"