Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

I am creating a spreadsheet to record unit finances. The spreadsheet I am using as a template/demo for mine has a hidden worksheet that I'm trying to view.

I have googled, and tried what has been suggested, including VBA.

What can I do to see this worksheet? (I would upload the file, but I don't know how)

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
146 views
Welcome To Ask or Share your Answers For Others

1 Answer

For a specific sheet:

Worksheets("MySheet").Visible = xlSheetVisible

Make all sheets in the workbook visible:

Sub MakeAllSheetsVisible()
    Dim sht As Worksheet

    For Each sht In Worksheets
        If Not sht.Visible Then
            sht.Visible = xlSheetVisible
        End If
    Next sht
End Sub

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share

548k questions

547k answers

4 comments

86.3k users

...