Thread: set an array of shapes visibility
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MM User MM User is offline
external usenet poster
  
Posts: 27
Default 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.

Reply With QuoteReply With Quote