The amazing not disappearing box

This seems truly bizarre to me so hopefully it's something stupid someone can help with.

On my sheet I have a series of conditionally formatted boxes to make them essentially vanish when I need them to. There are also two boxes involved. I drew a blank rectangle (automatically called "rectangle 1") and have copied a small picture from elsewhere in the book and renamed it "pic110" (learning from previous mistakes).

When there is a change in a given cell both the shapes are either hidden or shown. However, as it is only the rectanglebehaves as it should. The other box stays there all the time. They are in the same if statement and if I carve out the code for the pic and stick it as a seperate macor it will run ok (when manually run, nto when called by the worksheet_change event).

I'm going bald here. ANyone any ideas? Thanks in advance.

You don't fancy 20 questions then? CAn't share the workbook but here's the code.

Please Login or Register  to view this content.

Cell u8 is the cell that is used to conditionally format everything else as well - it's a simple y/n option. J7 is the cell the user changes. Rectangle 5 works perfectly but not pic110.

If I do:

Please Login or Register  to view this content.

And run either of them the ox disappears and reappears like magic. So I'm at an utter loss as to what the problem is.

Scrap all that. NO idea why but without changing it it now works. Been having a few issues like that lately. My personally favourite is where cell E3 shows £3,000, cell D3 says =E3 and D3 shows......£2,000.

Thanks anyway.

It's still called that but if I have problems again I'll certainly change it. Thanks for that piece of help though. I've really no idea why it has suddenly decided to work. It's getting temperamental in MY old age :-s

You may have misread that - or maybe I'm being thick. They were both formatted the same way - just the number shown wasn't the same. I tried another cell using E3 as the target and the same happened. Are you saying the format may change the number shows such as that?

Talking of which (seeing as you are being so helpful) sometimes I type in formule (or cut and paste) and the cell then shows the formula rather than the result. I have to cut the text, paste it elsewhere and then cut that cell back to the original position. Have I missed something there too?

The first two cells were formatted the same. I even went into the format cells dialogue box to double check and change the number type in case there was something odd. I tend to use custom format styles for shortcuts to make life easier.

re the formatted as text, they may have been before pasting but even after again changing the style it was showing the formula. It's not something that has ever happened to me until the last batch of spreadsheets I've had to do.

Going back to the £3,000 £2,000 thing - how could the format change what's shown? I understand if I used round or something I could change it (and similarly format I would guess ie from 2,345 to 2,000) but how would it work with 3,000 to 2,000. I'm intrigued now.

That's what I thought. JUst when you said you thought the formatting was different so that D3 and E3 should a different answer I thought I had missed something all these years. Glad I haven't

Thanks very much for your time. Much appreciated.

Not trying to hijack your thread, but so far this is the closest i have found to my issue even with a bunch of searching. You mentioned the name "pic110" is a cell reference and to change it so something else. How do you access that? I have a similar issue getting my code to move a picture behind a blank rectangle. I need to rename the picture object but I can't seem to figure out how.

Any tips?

Ah ha. Somethign I can help with

If you right click on the object you can go to properties and then rename the box in the window that appears. Hopefully that works for you

If that doesn't work - depends on the type of item I think - try this http://www.excelforum.com/excel-prog...ml#post3562424 That'll definitely sort it for you.