Can I make a range of cells in a worksheet read only ?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,

Select Cell Range
Go Format -> Cells -> Protection
Uncheck "Locked" checkbox
Go Tools -> Protection -> Protect Sheet
*optional: specify password (its case sensitive)

I hope this helps !

Reetesh B. Chhatpar
ShawMan Software Enterprises
www.shawmansoftware.com

Diamond is just another piece of coal that did well under pressure.
 
This protects the whole sheet. I require to have a block of cells on a
worksheet read only allowing other cells to have data added
 
Hi
- first select the cells for which you want allow entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect the sheet
 
Hi,

Press CTRL+A to select all cells of Active Sheet
Go Format->Cells->Protection
Uncheck "Locked" Checkbox
Use CTRL key and select all those cells which you want to keep locked for
other users
Go Format->Cells->Protection
Check "Locked" Checkbox
Go Tools -> Protection -> Protect Sheet
*optional: specify password (its case sensitive)

I hope this helps ! Should there be any further queries, please feel free to
contact : (e-mail address removed)

Reetesh B. Chhatpar
ShawMan Software Enterprises
www.shawmansoftware.com

Diamond is just another piece of coal that did well under pressure.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking Access in Read-Only Files 0
Code to format cells on several worksheets 2
Setting Scope of name ranges to particular worksheet 2
VBA set thick borders around non empty cells in range 0
Excel VBA 1
Display Worksheet Range in a Textbox 1
Copy a range data from 1 sheet to multiple selected sheets 1
AVERAGE cells on another worksheet when the range is calculated 1

Back
Top