View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gunnar Johansson Gunnar Johansson is offline
external usenet poster
 
Posts: 47
Default How select all pictures in a worksheet and make visible?

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