Have discovered a VERY annoying little bug, and was wondering if any of
you gurus knows a work around or a fix.

Say you have two worksheets, A and B with a comment in a cell on sheet
B. That comment is visable, and an arrow goes from the cell to the
comment.

if you want a cell on sheet A to reference a cell on sheet B which is
within an invisible box bounded by the arrow and the comment box, then
you cannot simply use the mouse cursor to select that cell ... you have
to either type the cell name in manually or select a cell outside that
invisible box and use the arrow keys to scroll to the cell you want to
reference.

This is odd because there are no issues if you want to make the same
reference on the same sheet as the comment, it only occurs if you are
making intersheet references.

Hopefully that is clear, and you can duplicate the bug, let me know if
it is not, and I might try and attach an example file or something.

Any ideas?


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=519234