close

The instructions in excel's help menu don't work.

Hi magician,

In most cases Format|Sheet|Unhide will display a list of hidden worksheets
attached to the workbook. Simply select the one you want to unhide, and
press OK.

If there are any other worksheets, they'll have been hidden with the
'xlveryhidden' property, which you'll need vba to unhide. For example:

Sub ShowAllSheets
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.Visible = True
Next
End Sub

Cheersquot;magicianquot; gt; wrote in message
...
gt; The instructions in excel's help menu don't work.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()