Positioning a comment help?

**CFerry_11** · 10-30-2011, 10:10 AM

Hi,
I am on Excel 2011 and I have to put a picture in a comment and have sorted everything except positioning it!
Every time I drag it into the position I was it to pop up into, and then test it, it always goes into the default position which is not where I want it. But I cannot get it to pop up into the position I want it to!
Can anybody help me? Or point out anything I may be doing wrong?
Thanks

**mrice** · 10-30-2011, 04:30 PM

This might help. It will make a comment appear in a defined position when a single cell is selected.

Please Login or Register  to view this content.

For this to work, the above code needs to be pasted into the appropriate sheet tab (e.g. Sheet1) in the VBA editor. Additionally, the text in the comment needs to specify the coordinates (e.g. 39.75,333) separated by a comma, The font can be sort of hidden by use of a suitably small font and appropriate colour.

**CFerry_11** · 10-30-2011, 06:54 PM

Originally Posted by mrice

This might help. It will make a comment appear in a defined position when a single cell is selected.

Please Login or Register  to view this content.

For this to work, the above code needs to be pasted into the appropriate sheet tab (e.g. Sheet1) in the VBA editor. Additionally, the text in the comment needs to specify the coordinates (e.g. 39.75,333) separated by a comma, The font can be sort of hidden by use of a suitably small font and appropriate colour.

Thanks alot! I shall try it out asap!