| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hideing and unhiding worksheets
Hi,
How can I hide and unhide worksheets base on a value of a cell which is in another sheet. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hideing and unhiding worksheets
If worksheets("Sheet 1").cells(1,1).value = "Show Sheet" then
worksheets("Sheet 2").visible = true else if worksheets("Sheet 1").cells(1,1).value = "Hide Sheet" then worksheets("Sheet 2").visible = false end if wrote it on the fly but it should work. 2007-User wrote: Hi, How can I hide and unhide worksheets base on a value of a cell which is in another sheet. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hideing and unhiding worksheets
Thanks John,
"John Fuller" wrote in message oups.com... If worksheets("Sheet 1").cells(1,1).value = "Show Sheet" then worksheets("Sheet 2").visible = true else if worksheets("Sheet 1").cells(1,1).value = "Hide Sheet" then worksheets("Sheet 2").visible = false end if wrote it on the fly but it should work. 2007-User wrote: Hi, How can I hide and unhide worksheets base on a value of a cell which is in another sheet. Thanks in advance. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hideing and unhiding worksheets
or just cut the bottom off:
If worksheets("Sheet 1").cells(1,1).value = "Show Sheet" then worksheets("Sheet 2").visible = true else worksheets("Sheet 2").visible = false end if John Fuller wrote: If worksheets("Sheet 1").cells(1,1).value = "Show Sheet" then worksheets("Sheet 2").visible = true else if worksheets("Sheet 1").cells(1,1).value = "Hide Sheet" then worksheets("Sheet 2").visible = false end if wrote it on the fly but it should work. 2007-User wrote: Hi, How can I hide and unhide worksheets base on a value of a cell which is in another sheet. Thanks in advance. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hideing and unhiding worksheets
Thanks,
"LooneyTunes" wrote in message oups.com... or just cut the bottom off: If worksheets("Sheet 1").cells(1,1).value = "Show Sheet" then worksheets("Sheet 2").visible = true else worksheets("Sheet 2").visible = false end if John Fuller wrote: If worksheets("Sheet 1").cells(1,1).value = "Show Sheet" then worksheets("Sheet 2").visible = true else if worksheets("Sheet 1").cells(1,1).value = "Hide Sheet" then worksheets("Sheet 2").visible = false end if wrote it on the fly but it should work. 2007-User wrote: Hi, How can I hide and unhide worksheets base on a value of a cell which is in another sheet. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print out hideing | Excel Discussion (Misc queries) | |||
| Unhiding all worksheets | Excel Programming | |||
| Unhiding worksheets | Excel Discussion (Misc queries) | |||
| Unhiding all worksheets. | Excel Programming | |||
| Unhiding worksheets | Excel Worksheet Functions | |||
Linear Mode
