Advertisement
Guest User

Untitled

a guest
Mar 25th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. Sub AnHien_Sheet()
  2. Dim lr As Long
  3. lr = Sheets("MENU").Cells(Rows.Count, 1).End(xlUp).Row
  4.  
  5. Dim sodong As Long
  6. 'An/hien sheet
  7. For sodong = 2 To lr
  8. 'Mo an tat ca cac sheet
  9. Worksheets(Sheets("MENU").Range("A" & sodong).Value).Visible = xlSheetVisible
  10. 'An sheet duoc danh dau
  11. If Sheets("MENU").Range("B" & sodong).Value = "x" Then
  12. Worksheets(Sheets("MENU").Range("A" & sodong).Value).Visible = xlSheetHidden
  13. End If
  14. Next sodong
  15.  
  16. Sheets("MENU").Activate
  17. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement