Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Banana
 
Posts: n/a
Default How do i lock sellected cells in a spreadsheet?

I need to lock some cells so other users cannot modify them. However, they
still need to modify other areas of the spreadsheet? Can i do this? If,
Yes... HOW?

Thanks...
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Click the select all button above row one and to the left of the column
header A to select sheet
Menu FormatCellProtection, uncheck the Locked option, OK
Select the range of cells to be locked
Menu FormatCellProtection, check the Locked option, OK
Menu ToolsProtectionProtect sheet.

--
HTH

Bob Phillips

"Banana" wrote in message
...
I need to lock some cells so other users cannot modify them. However, they
still need to modify other areas of the spreadsheet? Can i do this? If,
Yes... HOW?

Thanks...



  #3   Report Post  
Anne Troy
 
Posts: n/a
Default

Here you go, Banana:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Banana" wrote in message
...
I need to lock some cells so other users cannot modify them. However, they
still need to modify other areas of the spreadsheet? Can i do this? If,
Yes... HOW?

Thanks...



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
Auto Populating cells from a master spreadsheet Steve K Excel Discussion (Misc queries) 0 July 1st 05 05:01 PM
Scan and copy cells from one spreadsheet to another. Mark Excel Discussion (Misc queries) 1 April 6th 05 06:45 PM
How can I lock a number of cells within a worksheet? IGA Excel Discussion (Misc queries) 4 February 25th 05 01:38 AM
password protected certain cells in spreadsheet vv Excel Discussion (Misc queries) 2 February 9th 05 10:46 PM
How do I freeze or lock cells to show up on each page without typ. [email protected] Excel Discussion (Misc queries) 1 December 7th 04 05:22 AM


All times are GMT +1. The time now is 09:11 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"