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.
|