Hidding especific sheet

  • Thread starter Thread starter mik00725
  • Start date Start date
M

mik00725

In a workbook I have 10 different sheets. I want to hide 3 differen
sheets and leave the other unhide. How can I do this
 
worksheets("Sheet1").visible = xlSheetVisible
worksheets("Sheet2").visible = xlSheetHidden

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
something like
for each ws in worksheets
if ws.name <> "diff1" and ws.name<> "diff2") then ws.visible=false
next ws
 
Select the 3 sheets using CTRL + click on sheet tabs.

Format>Sheet>Hide


Gord Dibben MS Excel MVP
 
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

Custom View: Keeping worksheet hidden? 1
Expand and collapse rows 7
Unhide multiple sheets at the same time 4
Another quick question! Thanks! 5
Block a sheet from being unhidden 2
Hid a sheet in Excel 2003 Need to unhide it in Excel 2007 1
Excel Move or Copy Stopped Working? 0
VB Script for Copy Sheet 14

Back
Top