visible sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some sheets that are invisible.
I need a code that makes alla sheets in a workbook visible.
 
Could you do a for each loop that has a sheet.visible inside?? Tha
would work.
 
Hi
try

sub foo()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.visible=true
next
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

hide multiple worksheets based on a formula value in one cell 1
Hide Sheets when closing file 2
How to turn invisible sheets into visible? 0
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Can't delete sheets 8
Workbook open code to do 2 things 1
unhiding / hiding sheets 5
Excel2000 procedure in Excel2007 5

Back
Top