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.

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.

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.

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.

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.