Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Hide Selected Objects

0 views
Skip to first unread message

Clara

unread,
Jun 27, 2009, 10:09:01 AM6/27/09
to

Hi,

Anyone know how can i hide selected objects only instead of hiding all
objects in my worksheet?

Shane Devenshire

unread,
Jun 27, 2009, 10:40:02 AM6/27/09
to

Hi,

If you are refering to the command Tools, Options, View, Objects Hide All,
then the answer there is no such feature built into Excel.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

Gord Dibben

unread,
Jun 27, 2009, 12:27:35 PM6/27/09
to

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


On Sat, 27 Jun 2009 07:09:01 -0700, Clara <Cl...@discussions.microsoft.com>
wrote:

Shane Devenshire

unread,
Jun 27, 2009, 6:19:01 PM6/27/09
to

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

Jacob Skaria

unread,
Jun 28, 2009, 1:00:01 AM6/28/09
to

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
---------------
Jacob Skaria

0 new messages