Changing Comment Box Position - Any solutions?
 

Hello! I've tried every which way there is, but can't seem to get this right!

On mouseover on the red triangles I'd like the comment box to appear to the
left of the cell. I move and place it there, and save, but when I mouseover
the cell..it's back in its unwanted position!!! The only time when it's in
the position I want it to be is when I click on "edit comment"

Any way around this annoying quirk?

Thanks!

Changing Comment Box Position - Any solutions?
 

There are VBA solutions to the "wandering comment" problem. See:

http://www.contextures.com/xlcomments01.html
--
Gary's Student
gsnu200701


"Stilla" wrote:

Hello! I've tried every which way there is, but can't seem to get this right!

On mouseover on the red triangles I'd like the comment box to appear to the
left of the cell. I move and place it there, and save, but when I mouseover
the cell..it's back in its unwanted position!!! The only time when it's in
the position I want it to be is when I click on "edit comment"

Any way around this annoying quirk?

Thanks!

Changing Comment Box Position - Any solutions?
 

Thank you "Gary's Student," but I'm afraid my file cannot contain macros.

If anyone knows of a non-macro solution, please let me know.

"Gary''s Student" wrote:

There are VBA solutions to the "wandering comment" problem. See:

http://www.contextures.com/xlcomments01.html
--
Gary's Student
gsnu200701


"Stilla" wrote:

Hello! I've tried every which way there is, but can't seem to get this right!

On mouseover on the red triangles I'd like the comment box to appear to the
left of the cell. I move and place it there, and save, but when I mouseover
the cell..it's back in its unwanted position!!! The only time when it's in
the position I want it to be is when I click on "edit comment"

Any way around this annoying quirk?

Thanks!

Changing Comment Box Position - Any solutions?
 

The macros do not need to reside on the workbook that contains the data ro
comments. If you create a special workbook (say tools.xls) It can contain
macros that, with proper coding, can operate on the data and comments in a
separate workbook.
--
Gary's Student
gsnu200701


"Stilla" wrote:

Thank you "Gary's Student," but I'm afraid my file cannot contain macros.

If anyone knows of a non-macro solution, please let me know.

"Gary''s Student" wrote:

There are VBA solutions to the "wandering comment" problem. See:

http://www.contextures.com/xlcomments01.html
--
Gary's Student
gsnu200701


"Stilla" wrote:

Hello! I've tried every which way there is, but can't seem to get this right!

On mouseover on the red triangles I'd like the comment box to appear to the
left of the cell. I move and place it there, and save, but when I mouseover
the cell..it's back in its unwanted position!!! The only time when it's in
the position I want it to be is when I click on "edit comment"

Any way around this annoying quirk?

Thanks!

Changing Comment Box Position - Any solutions?
 

Yes, thanks for reminding me....however, this is still not a solution for me,
because I'll be sending the file to others, and there's a non-vba additions
requirement.

Thanks again.

"Gary''s Student" wrote:

The macros do not need to reside on the workbook that contains the data ro
comments. If you create a special workbook (say tools.xls) It can contain
macros that, with proper coding, can operate on the data and comments in a
separate workbook.
--
Gary's Student
gsnu200701


"Stilla" wrote:

Thank you "Gary's Student," but I'm afraid my file cannot contain macros.

If anyone knows of a non-macro solution, please let me know.

"Gary''s Student" wrote:

There are VBA solutions to the "wandering comment" problem. See:

http://www.contextures.com/xlcomments01.html
--
Gary's Student
gsnu200701


"Stilla" wrote:

Hello! I've tried every which way there is, but can't seem to get this right!

On mouseover on the red triangles I'd like the comment box to appear to the
left of the cell. I move and place it there, and save, but when I mouseover
the cell..it's back in its unwanted position!!! The only time when it's in
the position I want it to be is when I click on "edit comment"

Any way around this annoying quirk?

Thanks!