Missed you part of a greater routine.

if range("Sheet1!A1").Value then worksheets("Sheet2").Visible =
xlSheetHidden


or if A1 of sheet1 will always be true or false

Worksheets("Sheet2").Visible = Not Range("Sheet1!A1")

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
Use the calculate event to check the cell or if the cell would be changed
through manual entry, then use the change event.

There is no function you can place in a cell to perform this type of
action.

http://www.cpearson.com/excel/events.htm

Chip Pearson's page on events.

--
Regards,
Tom Ogilvy

"JPAUL" wrote in message
...
Hi All,

As part of a greater routine, I'd like to Hide a worksheet
if a certain condition exists in a cell located on a
different sheet. For example, If: Sheet1!A1 = TRUE, Hide
Sheet2.

Any help is appreciated.