LinkBack URL
About LinkBacks
There are note (I do mean note, not comment) in quite many cells, small percentage of note is too long, and I will need to resize them.
How to resize them globally (whole sheet, or whole workbook)?
There are note (I do mean note, not comment) in quite many cells, small percentage of note is too long, and I will need to resize them.
How to resize them globally (whole sheet, or whole workbook)?
Something like
Please Login or Register to view this content.
Thanks, I have not tested the code yet, maybe tonight. But I would like to say that it is not comment, it is note (per original post, per below screenshot). I guess your code ws.Comments.Count > 0 is for comment.
Last edited by AliGW; 11-04-2024 at 10:57 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead. Please review the forum guidelines.
@VAer
You have been asked not to quote unnecessarily. Please stop doing so (see the forum guidelines and your other thread). Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I only quote two words "something like" in this thread, not quoting the code. If there are multiple posts above my post, it is better to quote a little bit(get used to do so), so that other people can see which post I reply to.
But if that is the rule, I will pay attention to it.
Last edited by VAer; 11-04-2024 at 11:27 AM.
The old-style comment, now referred to as a "Note", is still referred to as a "Comment" in code. The new-style comments are referred as "ThreadedComments" in code.
@ByteMarks
Thanks for explaining, I will update the post status when I have time to test the code tonight.
@VAer
As you will have read in my note to your other thread, there is no need at all to quote the post immediately preceeding yours. If you want to clarify to whom you are replying, use @AliGW (or whichever member name is appropriate).
Thank you for following our guidelines.
@ByteMarks
Thanks for the code, it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks