Hide Selected Objects

  • Thread starter Thread starter Clara
  • Start date Start date
C

Clara

Hi,

Anyone know how can i hide selected objects only instead of hiding all
objects in my worksheet?
 
With VBA you could probably do this.

What type of objects are you referring to?

Selectable objects you have inserted like drawing objects or pictures?


Gord Dibben MS Excel MVP
 
Hi,

Following up on Gord's suggestion here is code that will hide the selected
objects, in this case shapes:

Selection.ShapeRange.Visible = False

Keep in mind that you can't reverse this by writing

Selection.ShapeRange.Visible = True

besause you can't select things you can't see. So in that case you need
something like this

ActiveSheet.Shapes.Range(Array("Rectangle 1", "Rectangle 2")).Visible = True
 
Hi Clara

Try the below macro. You dont need to select the object; instead just select
the cell range. All objects within selection will be hidden

Sub Macro1()
Dim obj As Object
For Each obj In ActiveSheet.DrawingObjects
If Not Intersect(obj.TopLeftCell, Selection) Is Nothing Then
obj.Visible = False
End If
Next
End Sub

If this post helps click Yes
 
Back
Top