Hide Method

See Also Applies To Example Model

Sets the object's appearance to invisible.

object expression.Hide

object expression    Required. An object expression that evaluates to an object in the Applies To list.

Remarks

This method is equivalent to setting the object's Visible property to False.

Use the Show method to set the objects display mode to visible.

Example

The following example uses the Hide and Show methods to make Cell objects visible if their "state" Tag value is equal to 1.

Cells.Hide
For Each Cell In Cells
     If Cell.Tags("state").Value = 1 Then Cell.Show
Next Cell