unhide multiple sheets

  • Thread starter Thread starter txbjones
  • Start date Start date
T

txbjones

How can I unhide several sheets all at once instead of one sheet at
time
 
You can do that with a macro, if it is the same sheets then you can record a
macro while you unhide
them and then next time run that macro.. Or you can use what I use


Sub UnhideSheet()
Application.ScreenUpdating = False
Dim mySht As Worksheet
For Each mySht In ActiveWorkbook.Worksheets
mySht.Visible = True
Next mySht
Application.ScreenUpdating = True
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse rows 7
Unhide Multiple Sheets at once 8
VB Script for Copy Sheet 14
Hide/Unhide Sheet Macro 6
Unhide multiple sheets at the same time 4
unhide sheets 4
Custom View: Keeping worksheet hidden? 1
Block a sheet from being unhidden 2

Back
Top