Posted to microsoft.public.excel.programming

MM User

external usenet poster

Posts: 27

set an array of shapes visibility

Hi,

Is it possible to use an array to set the visibility:

ActiveSheet.Shapes(Array("image1", "image2", "shape3", "shape5")).Visible =
True

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shapes Range Array	Bubb	Excel Discussion (Misc queries)	1	April 10th 06 11:51 PM
How do i read Selection.Shapes.Range(Array(i)?	Harry	Excel Programming	2	September 6th 05 03:46 PM
Trying To Store Shapes/Objects to an array ??	Tom Ogilvy	Excel Programming	2	September 21st 04 09:49 PM
Trying To Store Shapes/Objects to an array ??	Dan Thompson	Excel Programming	0	September 21st 04 08:37 PM
PROB: Grouping Shapes With An Array Loop	Boicie	Excel Programming	2	January 14th 04 08:21 PM

All times are GMT +1. The time now is 06:44 PM.

About Us

"It's about Microsoft Excel"