Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a particular cell alone as Read-only
All,
I need to make programatically some cells in Excel sheet as Read-only, So, that user should not be allowed to edit the contents of that particular cells, where as users can edit the other cells in the same sheet. I'm not intersted in making complete sheet as read-only. Is there any way i can acheive the above requirements. Thanks, S.Annamalai |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a particular cell alone as Read-only
On Apr 16, 7:15*am, Annamalai.S
wrote: All, * *I need to make programatically some cells in Excel sheet as Read-only, So, that user should not be allowed to edit the contents of that particular cells, where as users can edit the other cells in the same sheet. I'm not intersted in making complete sheet as read-only. Is there any way i can acheive the above requirements. Thanks, S.Annamalai Try this: I used Sheet1 and D3:D7 as my protected range, yours will be different. I have added an If clause in case your sheet is already protected. Sub ProtectCells() With Worksheets("Sheet1") If Sheet1.ProtectContents Then .Unprotect ("password") End If .Cells.Locked = False .Range("D3:D7").Locked = True .Protect ("your password here") End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make an execl cell A3 read-only based on A4? | Excel Discussion (Misc queries) | |||
How do I make read-only file | Excel Discussion (Misc queries) | |||
How to make a File READ ONLY | Excel Programming | |||
how to make cell read only | Excel Programming |