textbox and images disappear

[Blake 7]

Hi Guys,

I have created a spreadsheet which contains a couple of pivot tables, a data table and some graphs. The data table looks at a single cell from a drop down.

On this sheet I have a text box and a couple of images.

Whenever I either, make a new selection from the report filter in the pivots or select a new value from the dropdown the images and textbox disappear.

I then have to go into the selection paine to select them again grrrrr.


Does anybody know how to resolve this?

Many thanks

[Blake 7]

inserting a shap underneath seems to work but not sure how robust / reliable this method is!

[Andy Pope]

Does your workbook contain code that may hide all pictures?

Please Login or Register  to view this content.

[Blake 7]

Ahhhh ha!

Some of it does............. i use this code below

Please Login or Register  to view this content.

combind with this

Please Login or Register  to view this content.

to look up images.

So this is playing havoc with the other images , ummmmmmmm! is there a way to EXCLUDE the images I always want to display?

[Andy Pope]

You would need to loop through the pictures and test a property, such as name or position, and set the visible property on a per picture basis.

[Blake 7]

Many thanks Andy - sorry for the delayed acknowledgement of your response. Cheers