Make shape visible/invisibale based on change of cell in different worksheet

Hi.

I'm attempting to code a worksheet change which allows for an autoshape to disappear based on cell results from a different sheet.

I thought I had it but id doesn't re-run the macro when the cell is changed and therefore, the shape stays gone until an entry is made on the sheet,

Here is what I'm trying to incorporate together.

Thansk for the help.

Please Login or Register  to view this content.

This thread is more than 2 yrs old. Its better you start your own.