How to show hidden sheets?

  • Thread starter Thread starter ghost
  • Start date Start date
G

ghost

Greeting,
Is there any code to show all hidden sheets in worksheet?
Thanks
 
Unless they are xlveryhidden you don't need code, simply unhide them with

Format|sheet|Unhide

Mike
 
For Each sh In ACtiveworkbook.Worksheets

sh.Visible = xlSheetVisible
Next sh

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
hi
as in vb code?
Dim WS As Worksheet
For Each WS In Worksheets
WS.Visible = True
Next WS

untested. watch for typos
regards
FSt1
 
Hi Mike and thank you for response
When I go to Microsoft VB, Worksheet project has 25 sheets, while in the
sheet tab; there are five sheets only, Please advice?
Thank you again
 
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

copy hidden sheet data 2
2003/2007 Compatibility Issue - Hidden Sheets 4
Displaying results in formula bar when cell is hidden 1
reading data from hidden sheet 4
Re-post: Code to make sheet very hidden based on date 1
Function To Select the Hidden Rows & Columns in the Current Sheet 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Hidden sheet: 2003 vs 2007 1

Back
Top