Re: Hide Selected Objects
- From: Shane Devenshire <ShaneDevenshire@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 27 Jun 2009 15:19:01 -0700
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
"Gord Dibben" wrote:
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 <Clara@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hi,
Anyone know how can i hide selected objects only instead of hiding all
objects in my worksheet?
- References:
- Hide Selected Objects
- From: Clara
- Re: Hide Selected Objects
- From: Gord Dibben
- Hide Selected Objects
- Prev by Date: * instead of value
- Next by Date: RE: Too many characters in header
- Previous by thread: Re: Hide Selected Objects
- Next by thread: RE: Hide Selected Objects
- Index(es):
Relevant Pages
|
