ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to change the default position of a comment box (https://www.excelbanter.com/excel-discussion-misc-queries/44853-how-change-default-position-comment-box.html)

Hans Feitz

how to change the default position of a comment box
 
If a cell with a comment assigned to it is towards the edge of the (RH) side
of the window, the comment box will only be partially visible. Can the
default position of these boxes be changed to f.i. LH side of the cell? I
know that during editing the text box position can be changed but that is not
reflected permanently afterwards.

Dave Peterson

I don't think you can change the default position of the comment.

But you could use a macro to reposition them each time the workbook opens.

Debra Dalgleish has some code that may help you get started at:
http://contextures.com/xlcomments03.html#Reset

You could modify Debra's code to go through each worksheet and name it Auto_open
so that it runs when the workbook opens.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Hans Feitz wrote:

If a cell with a comment assigned to it is towards the edge of the (RH) side
of the window, the comment box will only be partially visible. Can the
default position of these boxes be changed to f.i. LH side of the cell? I
know that during editing the text box position can be changed but that is not
reflected permanently afterwards.


--

Dave Peterson


All times are GMT +1. The time now is 05:22 AM.

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