set an array of shapes visibility

  • Thread starter Thread starter MM User
  • Start date Start date
M

MM User

Hi,

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

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

Thanks
 
hi, !
Is it possible to use an array to set the visibility:
ActiveSheet.Shapes(Array("image1", "image2", "shape3", "shape5")).Visible = True
Click to expand...

try with:

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

hth,
hector.
 
Thanks Hector!



Héctor Miguel said:
hi, !


try with:

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

hth,
hector.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shape Arrays VBA 0
Show shape on cell select, Hide shape when cell is deselected 5
Hide rows using VBA based on cell value 0
Click to Add Image 3
Individualized image visiblilty in continuus form? 3
Looping Macro - Run Time Error 4
List image names into col & fill cell comments with corresp images 2
How to enumerate buttons on user form 2

Back
Top