| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide and Unhide
In my excel workbook i hv created two command buttons one is S and the other
is I I need a code so that when i click on S button it should unhide few sheets(X, Y, Z are the three sheets) and again second time when i click the same S button it should hide the visible sheet(X,Y,Z) Same way for button I, when i click on I button it should unhide few sheets(E,F,G are the three sheets) and again second time when i click the same I button it should hide the visible sheet(E,F,G) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide and Unhide
Dear Ranjith
Use the IIF function Sheets("X").Visible= IIf(Sheets("X").Visible,false,true) Sheets("Y").Visible= IIf(Sheets("Y").Visible,false,true) Sheets("Z").Visible= IIf(Sheets("Z").Visible,false,true) If this post helps click Yes --------------- Jacob Skaria "Ranjith Kurian" wrote: In my excel workbook i hv created two command buttons one is S and the other is I I need a code so that when i click on S button it should unhide few sheets(X, Y, Z are the three sheets) and again second time when i click the same S button it should hide the visible sheet(X,Y,Z) Same way for button I, when i click on I button it should unhide few sheets(E,F,G are the three sheets) and again second time when i click the same I button it should hide the visible sheet(E,F,G) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide and Unhide
OR
Sheets("X").Visible= not Sheets("X").Visible Sheets("Y").Visible= not Sheets("Y").Visible Sheets("Z").Visible= not Sheets("Z").Visible -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Dear Ranjith Use the IIF function Sheets("X").Visible= IIf(Sheets("X").Visible,false,true) Sheets("Y").Visible= IIf(Sheets("Y").Visible,false,true) Sheets("Z").Visible= IIf(Sheets("Z").Visible,false,true) If this post helps click Yes --------------- Jacob Skaria "Ranjith Kurian" wrote: In my excel workbook i hv created two command buttons one is S and the other is I I need a code so that when i click on S button it should unhide few sheets(X, Y, Z are the three sheets) and again second time when i click the same S button it should hide the visible sheet(X,Y,Z) Same way for button I, when i click on I button it should unhide few sheets(E,F,G are the three sheets) and again second time when i click the same I button it should hide the visible sheet(E,F,G) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide and Unhide
Did that help or am I missing something?
If this post helps click Yes --------------- Jacob Skaria "Ranjith Kurian" wrote: In my excel workbook i hv created two command buttons one is S and the other is I I need a code so that when i click on S button it should unhide few sheets(X, Y, Z are the three sheets) and again second time when i click the same S button it should hide the visible sheet(X,Y,Z) Same way for button I, when i click on I button it should unhide few sheets(E,F,G are the three sheets) and again second time when i click the same I button it should hide the visible sheet(E,F,G) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Unhide | Excel Discussion (Misc queries) | |||
| hide-unhide | Excel Programming | |||
| hide/unhide | Excel Programming | |||
| Hide - Unhide | Excel Programming | |||
| Hide/unhide | Excel Worksheet Functions | |||
![Ranjith Kurian[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
