|
hiding rows or columns
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 |
hiding rows or columns
Sure, Details???
-- Don Guillett Microsoft MVP Excel SalesAid Software "jaz" wrote in message ... 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 |
hiding rows or columns
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 "Don Guillett" wrote: Sure, Details??? -- Don Guillett Microsoft MVP Excel SalesAid Software "jaz" wrote in message ... 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 |
hiding rows or columns
or to make it more clear:
if account 1 is selected then unhide or hide rows 40,41 thanks in advance jez "Don Guillett" wrote: Sure, Details??? -- Don Guillett Microsoft MVP Excel SalesAid Software "jaz" wrote in message ... 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 |
hiding rows or columns
Right click sheet tabview codeinsert thismodify 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 Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... or to make it more clear: if account 1 is selected then unhide or hide rows 40,41 thanks in advance jez "Don Guillett" wrote: Sure, Details??? -- Don Guillett Microsoft MVP Excel SalesAid Software "jaz" wrote in message ... 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 |
hiding rows or columns
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 -- Don Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... 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 "Don Guillett" wrote: Right click sheet tabview codeinsert thismodify 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 Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... or to make it more clear: if account 1 is selected then unhide or hide rows 40,41 thanks in advance jez "Don Guillett" wrote: Sure, Details??? -- Don Guillett Microsoft MVP Excel SalesAid Software "jaz" wrote in message ... 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 |
hiding rows or columns
it does work very well indeed thank you very much
thank you "Don Guillett" wrote: 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 -- Don Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... 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 "Don Guillett" wrote: Right click sheet tabview codeinsert thismodify 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 Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... or to make it more clear: if account 1 is selected then unhide or hide rows 40,41 thanks in advance jez "Don Guillett" wrote: Sure, Details??? -- Don Guillett Microsoft MVP Excel SalesAid Software "jaz" wrote in message ... 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 |
hiding rows or columns
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... it does work very well indeed thank you very much thank you "Don Guillett" wrote: 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 -- Don Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... 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 "Don Guillett" wrote: Right click sheet tabview codeinsert thismodify 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 Guillett Microsoft MVP Excel SalesAid Software "jez" wrote in message ... or to make it more clear: if account 1 is selected then unhide or hide rows 40,41 thanks in advance jez "Don Guillett" wrote: Sure, Details??? -- Don Guillett Microsoft MVP Excel SalesAid Software "jaz" wrote in message ... 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 |
| All times are GMT +1. The time now is 09:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com