Hiding sheets in a workbook with VB

Hello Brad J.,

This example uses Sheet1 as the worksheet name. Substitute the name of the worksheet you want to hide for Sheet1.

Example of Hidding a Worksheet using a Variable:

If Variable = Condition Then
Worksheets("Sheet1").Visible = False
End If

To Prevent the User from Changing the Setting Use:

If Variable = Condition Then
Worksheets("Sheet1").Visible = xlVeryHidden
End If
The only way to make the worksheet visible again is thorugh code by setting Visible = True.

Hope this answers your question,
Leith Ross