Unhiding multiple worksheets in Excel 2000

[Juana Cafe]

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



In article <4935ECDF-B333-4B1F-B940-32B38C977036@microsoft.com>,
"Juana Cafe" <JuanaCafe@discussions.microsoft.com> wrote:

> 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.