ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Comment Location (https://www.excelbanter.com/excel-programming/375864-comment-location.html)

ploddinggaltn

Comment Location
 
I've added comments to the right side of a spreadsheet and when they display,
they display out of view. I've tried moving the comment to the left of the
cell and it moves, but does not stay there. When the file is opened back up
again, the comment opens off the screen to the right again. Is there a way
to lock the location of where a comment opens? Thanks for your help

Gary''s Student

Comment Location
 
Its hard to make them stick near to their origninal position, but its very
easy to re-set them. See:


http://www.contextures.com/xlcomments03.html#Reset
--
Gary's Student


"ploddinggaltn" wrote:

I've added comments to the right side of a spreadsheet and when they display,
they display out of view. I've tried moving the comment to the left of the
cell and it moves, but does not stay there. When the file is opened back up
again, the comment opens off the screen to the right again. Is there a way
to lock the location of where a comment opens? Thanks for your help



All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com