Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Hide sheets

  Asked By: Mindy    Date: Mar 16    Category: MS Office    Views: 1226
  

Can any one please tell me how to i hide the sheets?
Thanks,

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Clay Cook     Answered On: Mar 16

Yes

Sheets("sheet1").Visible = False

 
Answer #2    Answered By: Josephine Gomez     Answered On: Mar 16

In Excel, you can use the menu with Format...Sheet...Hide. (it will
hide the open sheet).

In VBA you can use this, assuming you want to hide  Sheet2:

Sheets("Sheet2").Visible = False

 
Didn't find what you were looking for? Find more on Hide sheets Or get search suggestion and latest updates.




Tagged: