Unhiding multiple worksheets in Excel 2000

[Guest]

Any way to unhide multipe sheets without going to Format>Sheet>Unhide for
EACH sheet individually ? I am talking about a very large number of hidden
sheets in multiple workbooks, so a macro would probably not work. Are there
any keyboard shortcuts ?? Excel doesn't offer the Shift+click/Ctrl+click
selection in the Unhide box. Thank you.

 

[JE McGimpsey]

Only using a macro. One way:

Public Sub UnhideAll()
Dim ws As Worksheet
For Each ws in Worksheets
ws.Visible = True
Next ws
End Sub

If you're unfamiliar with macros, see

http://www.mvps.org/dmcritchie/excel/getstarted.htm