ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Comment Box Positioning Q (https://www.excelbanter.com/excel-worksheet-functions/135280-comment-box-positioning-q.html)

Sean

Comment Box Positioning Q
 
Is it possible to move a Comment Box that is displayed, via code?

I have a number of sheets that I copy, but each time I do, the Comment
Boxes (on the Export sheets) are not in the position I want them.

Thanks


Dave Peterson

Comment Box Positioning Q
 
Debra Dalgleish shares some code that puts the comments back to the original
position. Maybe you can use it to position your comments where you want them:

http://contextures.com/xlcomments03.html#Reset



Sean wrote:

Is it possible to move a Comment Box that is displayed, via code?

I have a number of sheets that I copy, but each time I do, the Comment
Boxes (on the Export sheets) are not in the position I want them.

Thanks


--

Dave Peterson


All times are GMT +1. The time now is 07:13 PM.

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