Checked : Office 2007.

 

[Excel 매크로] 모든 워크시트의 숨기기 취소


Sub CancelHiddenWorksheet()
    Dim wksht As Worksheet
    For Each wksht In ActiveWorkbook.Worksheets
        wksht.Visible = xlSheetVisible
    Next wksht
End Sub

Posted by 블로거

댓글을 달아 주세요