显示与隐藏工作表的一些方法

tmtony

原创:Designed by Tommy Flynn

' The distinction between Hide(False) and xlVeryHidden:

' Visible = xlVeryHidden - Sheet/Unhide is grayed out. To unhide sheet, you must set

' the Visible property to True.

' Visible = Hide(or False) - Sheet/Unhide is not grayed out



' To hide specific worksheet

Sub Hide_WS1()

    Worksheets(2).Visible = Hide  ' you can use Hide or False

End Sub





' To make a specific worksheet very hidden

Sub Hide_WS2()

    Worksheets(2).Visible = xlVeryHidden

End Sub





' To unhide a specific worksheet

Sub UnHide_WS()

    Worksheets(2).Visible = True

End Sub





' To toggle between hidden and visible

Sub Toggle_Hidden_Visible()

    Worksheets(2).Visible = Not Worksheets(2).Visible

End Sub

joyark

受益非浅

gdys01

受益非浅