hiding rows or columns

  • Thread starter Thread starter jaz
  • Start date Start date
J

jaz

hello there
i wonder if anybody could help me with this

is there a way probably macro that hides rows or columns if a specific
number is entered on A1 for example?
many thanks
jez
 
yes, i have some rows that i want to be displayed only by a member in one sheet
all of them have account codes eg: 1, 2, 3 on b3
i have created a list which allows them to enter the account code so i want
something that once account number 1 is selected from the list then it will
hide or unhide the rows that belongs to the acc 1, preferably unhide
memebers are up to 40 so it would be esential to unhide instead

cheers
jez
 
or to make it more clear:
if account 1 is selected then unhide or hide rows 40,41
thanks in advance
jez
 
Right click sheet tab>view code>insert this>modify to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("a1").Address Then
Dim x As String
Rows.Hidden = False 'Visible = True
Select Case Target
Case 1: x = "40:41"
Case 2: x = "4:8"


Case Else
Exit Sub
End Select
Rows(x).Hidden = True
End If
End Sub
 
don
i did try this but could not get it working

more specific is this:
if cell J3="58" then unhide rows 82-97 otherwise hide them
i need to unhide it only for this account code
many thanks
jez
 
Make sure it's in the sheet module of the desired sheet.
If your cell value is a number don't use the " "
Try this. If all else fails, send your wb to my address below

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("j3").Address Then
Dim x As String
Rows.Hidden = True
Select Case Target
Case 53: x = "82:97"
' Case 2: x = "4:8"
Case Else
Exit Sub
End Select
Rows(x).Hidden = false
End If
End Sub
 
Back
Top