Solved: Hide worksheets

[mprochello]

I would like to use vba to hide a worksheet based upon a value entered via dropdown list on another worksheet within the workbook. How can this be done?

Thanks for your assistance!

[Bob Phillips]

If Worksheets("Sheet1").Range("A1") = "some value" Then

Worksheets("Sheet2").Visible = xlSheetHidden
Else

Worksheets("Sheet2").Visible = xlSheetVisible
End If

[mprochello]

Thanks!