Another way with cell comments.
One problem with complex (very numerous cells) with comments is that as the
user moves the cursor through the worksheet, comments keep popping up €“ can
be quite an annoyance. Is there another way? €“ user clicks on a cell, box
comes up on screen with text, user clicks in the text box and text box
disappears. The click cells are not data cells, only title cells. Also,
would this system work when the cell is locked and protection invoked?
For example: merged cell range B7, user clicks cell B7, text box comes up
with text: €śPerson Responsible€ť, user clicks somewhere in the text box and it
disappears.
|