hkgal
asked on
Prevent user to unhide rows
I got a code and works well on hide/unhide info base on column G values:
Sub HideData()
Dim cel As Range
For Each cel In Columns("G")
If LCase(Trim(cel.Text)) = "NIL" Then
Rows(cel.Row).EntireRow.Hi dden = True
End If
Next cel
End Sub
Sub SHOWData()
Dim cel As Range
For Each cel In Columns("G")
If LCase(Trim(cel.Text)) = "NIL" Then
Rows(cel.Row).EntireRow.Hi dden = False
End If
Next cel
End Sub
However, I want to protect and prevent the users to unhide the row information when it is hidden. Any method?
Help....thanks!
Sub HideData()
Dim cel As Range
For Each cel In Columns("G")
If LCase(Trim(cel.Text)) = "NIL" Then
Rows(cel.Row).EntireRow.Hi
End If
Next cel
End Sub
Sub SHOWData()
Dim cel As Range
For Each cel In Columns("G")
If LCase(Trim(cel.Text)) = "NIL" Then
Rows(cel.Row).EntireRow.Hi
End If
Next cel
End Sub
However, I want to protect and prevent the users to unhide the row information when it is hidden. Any method?
Help....thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well... and what about erasing those rows from the sheet? If users shouldn't be able to see them in any manner what's the point of having them there?
You could put the rows in a different sheet and then hide/protect the sheet.
ASKER
So no ways to hide the rows at the same time set things to prevent unhide?? in same place n worksheet?
I don't believe there is.
I don't know any way to directly block a cell or a row/column from show/hide.
Maybe by rendering them readonly? Have you tried it?
Maybe by rendering them readonly? Have you tried it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER