ExcelBanter - set an array of shapes visibility

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - set an array of shapes visibility (https://www.excelbanter.com/excel-programming/416021-set-array-shapes-visibility.html)

MM User

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

Héctor Miguel

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

try with:

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

hth,
hector.

MM User

set an array of shapes visibility

Thanks Hector!

"Héctor Miguel" wrote in message
...
hi, !

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

try with:

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

hth,
hector.

All times are GMT +1. The time now is 05:48 PM.