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.