Unhiding multiple worksheets in Excel 2000
Any way to unhide multipe sheets without going to FormatSheetUnhide 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. |
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 , "Juana Cafe" wrote: Any way to unhide multipe sheets without going to FormatSheetUnhide 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. |
All times are GMT +1. The time now is 02:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com