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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
