From the menu you can only unhide worksheets 1 at at time, at least in Excel
2000.

The following macros might help though:
-------------------------------------------------------------------------------------------------

Sub UnhideAllSheets()

Dim wb As Workbook
Dim ws As Worksheet

Set wb = ActiveWorkbook

For Each ws In wb.Worksheets
If Not Sheets(ws.Name).Visible Then
Sheets(ws.Name).Visible = True
End If
Next ws

Set wb = Nothing
Set ws = Nothing


End Sub

-------------------------------------------------------------------------------------------------

Sub UnhideSheetsYesNo()

Dim iYesNo As Integer
Dim wb As Workbook
Dim ws As Worksheet

Set wb = ActiveWorkbook

For Each ws In wb.Worksheets

If Not Sheets(ws.Name).Visible Then
iYesNo = MsgBox("Unhide sheet " & ws.Name & _
"?", vbQuestion + vbYesNo, _
"Unhide This Sheet")
If iYesNo = vbYes Then
Sheets(ws.Name).Visible = True
End If
End If
Next ws

Set wb = Nothing
Set ws = Nothing

End Sub
-------------------------------------------------------------------------------------------------

The first macro (UnhideAllSheets) cycles through all the worksheets and if
they're not visible, makes them visible. The second macro
(UnhideSheetsYesNo) cycles through all the worksheets in the workbook,
prompting the user when it encounters a hidden sheet to unhide the sheet, yes
or no. It continues to cycle through all the worksheets in the workbook,
prompting for each hidden worksheet

Hope this helps...
--
Kevin Backmann


"weeclaire" wrote:


Hi All

Please can anyone help. On Microsoft Excel 2000 is there a way to
unhide more than one hidden tab at the same time?

Thanks guys!

Wee Claire


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=508895