Show Method

See Also Applies To Example Model

Sets the object's appearance to visible.

object expression.Show

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 True.

Use the Hide method to set the object's appearance to invisible.

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