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 |
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/ |
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/ |
All times are GMT +1. The time now is 04:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com