hiding a diagram

[tomk2005]

Hello everyone.
Im trying to make a diagram on a excel that will appear when ill write "yes" in a certain box, and that will disappear when the same box is empty. the diagram is a simple "Cake" form. Ill be happy to get some help, thx ahead,
Tom.

[tomk2005]

Hi everyone, I have two problems that I hope you can help with.
The first one is I simply wish to make a diagram appear when I type "yes" into cell O1, and to disappear when I type nothing in it.The diagram is a simple cake diagram. problem is Im a bit clueless about VB. if anyone can make me a code or direct me to a place I could learn to built a code from, I'll thank him.

The other one is a bit more tricky. I need to make some rows appear and disappear automatically.I wrote a date that appears and disappears in each first cell in a row (A4,A5----A34) (for example cell A7 - =IF(TODAY()<>DATE(2007,11,4),IF(SUM(B7:F7)=0,"",DATE(2007,11,4)),DATE(2007,11,4))), and the date is different in every row (from the 1st to nov to the 30).it simply make the date disappear if its yet to come or if it passed and the cells in B:F of the same row is empty (their sum is 0 - couldnt find a condition that reffers to the cell being blank). problem is that that cells in the column A:L stays blank and that is not good. I need the cells under the rows with the blank cells in coumn A:L to replace them (only if the two conditions I stated are true, only in lines 4-34).another problem is that cells M4:T8 can't be moved.Again, if anyone has any idea ill be thankfull.

Thanks alot anyway,
Tom.

[Paul]

Hello tomk,

The following macro would hide a drawing object named 'Rectangle 1' on your worksheet. I believe this method would also apply to a 'diagram', since it is also a drawing object (or group of objects). If it is a group, you may have to adjust the code to include all objects in that diagram.

Please Login or Register  to view this content.

This code is looking for any change in cell D1 only, and if D1's value changes to 'Yes' the diagram will appear, otherwise it will be hidden.