Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making some rows uneditable
Hi,
I wanted only some rows to be non editable by the user and rest of th rows should be editable. I know that this is possible using th protection option, but in this case it locks the whole worksheet. I wa to lock only certain ranges in the worksheet without having to give an password. How can this be done? Thanks, Samee -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making some rows uneditable
Hi Sameer
Protection locks everything that you haven't spesifically marked "not locked". So that's what you have to do, there are no "just a little protection" methods anywhere. -- HTH. Best wishes Harald Followup to newsgroup only please "sameerce " skrev i melding ... Hi, I wanted only some rows to be non editable by the user and rest of the rows should be editable. I know that this is possible using the protection option, but in this case it locks the whole worksheet. I wat to lock only certain ranges in the worksheet without having to give any password. How can this be done? Thanks, Sameer --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making some rows uneditable
Hi sameerce;
For example (the user is likely to be surprised) Dim oldCell As String Private Sub Worksheet_SelectionChange(ByVal Target As Range) If oldCell = "" Then oldCell = "A1" Select Case Target.Row Case 10, 12, 14, 16, 21 To 23: Range(oldCell).Select Case Else: oldCell = Target.Address End Select End Sub MP "sameerce " a écrit dans le message de ... Hi, I wanted only some rows to be non editable by the user and rest of the rows should be editable. I know that this is possible using the protection option, but in this case it locks the whole worksheet. I wat to lock only certain ranges in the worksheet without having to give any password. How can this be done? Thanks, Sameer --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel bug? cell comments become uneditable | Charts and Charting in Excel | |||
can I make a tab in an excel document uneditable? | Excel Discussion (Misc queries) | |||
Comment becomes uneditable, cell flashes | New Users to Excel | |||
Pivot chart uneditable | Charts and Charting in Excel | |||
How to Make Graphic Uneditable | Excel Discussion (Misc queries) |