have you tried recording a macro? also, why "multiple sheet at a time"?
I have a loop that looks through 100 sheets and hides all sheet names that begin with "MTR" I also unhide all sheets. It happens almost instantaneous. (OK, 1-2 seconds) '------------------------------------------------------------------ Option Explicit Sub Unhide_Sheets() Dim i Application.ScreenUpdating = False For i = 1 To Sheets.Count Sheets(i).Visible = True Next i Application.ScreenUpdating = True End Sub '------------------------------------------------------------------ Sub Hide_Sheets() Dim i Application.ScreenUpdating = False For i = 1 To Sheets.Count If (UCase(Left(Sheets(i).Name, 3)) = "MTR") Then Sheets(i).Visible = False End If Next i Application.ScreenUpdating = True End Sub '------------------------------------------------------------------ Paul ________________________________ From: santanu_ca <santanu...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Thu, September 9, 2010 11:13:47 AM Subject: $$Excel-Macros$$ Hide and unhide multiple sheet. Hi I want to hide multiple sheet at a time & Unhide multiple sheet at a time. Please help me with a working macro. Santanu -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
