- ©«¤l
- 12
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 365
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2022-2-1
- ³Ì«áµn¿ý
- 2022-12-29
|
¦^´_ 1# goner
¨Ì§Aªº´£°Ý ¦p¤U¹Ï¤ù ¦b½d³ò¤ºªº¹B§@¬Ý¬Ý
Á`ªíªºµ{¦¡½X¦p¤U- Option Explicit
- Private Sub CommandButton1_Click() '¨ú®øÁôÂÃ¥þ³¡¤u§@ªíªº«öÁäµ{¦¡½X
- Dim Sh As Worksheet
- Application.ScreenUpdating = False
- For Each Sh In Sheets
- Sh.Visible = True
- Next
- Application.ScreenUpdating = True
- End Sub
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count = 1 Then HideSheet Target
- End Sub
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Count = 1 Then HideSheet Target
- End Sub
- Sub HideSheet(Target As Range)
- Dim Rng As Range, A²Õ As String, E As Variant
- If Application.Intersect(Range("A1").CurrentRegion, Target) Is Nothing Then Exit Sub
- Application.EnableEvents = False '¤£Ä²°Ê Worksheet¹w³]¨Æ¥óµ{¦¡
- On Error GoTo Err 'µ{¦¡²£¥Í¿ù»~®É²¾¨ì ¼Ð°OÂI
- With Range("A1").CurrentRegion
- Set Rng = Range(.Cells(2, Target.Column), .Cells(.Rows.Count, Target.Column))
- End With
- A²Õ = "Á`ªí" 'A²Õ = "Á`ªí,ªí1,ªí2,ªí3" ' ***¥i×§ï ¥²¶·Åã¥Üªº¤u§@ªí
- For Each E In Rng
- A²Õ = A²Õ & "," & E
- Set Target = E
- Debug.Print TypeName(Sheets(E.Value)) ' '´ú¸ÕÀx¦s®æªº¤u§@ªí¦WºÙ¬O§_¦s
- Next
- A²Õ = "," & A²Õ & "," '
- Application.ScreenUpdating = False
- For Each E In Sheets
- E.Visible = InStr(UCase(A²Õ), "," & UCase(E.Name) & ",") > 0
- '* ¤ñ¹ï§¹¥þ¬Û¦Pªº¤u§@ªí¦WºÙ ->> "," & UCase(i.Name) & ","
- Next
- Application.ScreenUpdating = True
- Application.EnableEvents = True '¦^´_IJ°Ê Worksheet¹w³]¨Æ¥óµ{¦¡
- Exit Sub
- Err: '³B²zµ{¦¡½Xªº¿ù»~
- MsgBox IIf(Target <> "", " §ä¤£¨ì ¤u§@ªí [" & Target & "]", Target.Address(0, 0) & "¨S¦³¿é¤J....")
- Application.EnableEvents = True '¦^´_IJ°Ê Worksheet¹w³]¨Æ¥óµ{¦¡
- End Sub
½Æ»s¥N½X |
|