you probably could assign a macro that would resize the shape for you depending on a cell value.