ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Re-size Comments Box (https://www.excelbanter.com/excel-programming/417898-re-size-comments-box.html)

Chilired

Re-size Comments Box
 
I utlized Debra Dalgleish Resize Comments macro on a sheet that is protected.
It appeared to work okay, however the larger comments runs off the screen to
the left and users are not permitted to scroll up or down in the comments.
How can I use auto-size, but limit the widith of the box so it remains
visible on the screen without making all the boxes the same size?

Chilired.


All times are GMT +1. The time now is 08:46 AM.

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