How select all pictures in a worksheet and make visible?

  • Thread starter Thread starter Gunnar Johansson
  • Start date Start date
G

Gunnar Johansson

I have a vba code that has worked well for a while, but during some changes
all pictures become hidden when I run the code. I have searched for a
explanation and will contiune, but would need a quick and dirty solution
right now to just tell them in the end of the code like:
"Worksheet(1).pictures.visible = True" .

Of course is the above mentioned example not working, but it give the idea
of my needs. Probably the solutions is a for each..next solution and that's
ok, of cource.

NOTE:
You have to separate it from the chartobjects also within the worksheet

/
Reagrds
 
Gunnar -

This does all shapes, including chart objects and pictures:

for each shp in activesheet.shapes
shp.visible=true
next

This does just the picture type of shapes:

for each pic in activesheet.pictures
pic.visible=true
next

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top