How to enlarge Excel cells comment via VB.NET

H

harry

Hi,

Is it possible to enlarge an Excel cells comment using Automation via
VB.NET?

No problem creating comment however when viewing under excel, because the
comments are usually a couple of lines, I need to manually edit every
comment simply to enlarge the comment window.

Thanks
Harry
 
H

harry

never mind, finally got it....

oRng.Comment.Shape.ScaleWidth(3, Microsoft.Office.Core.MsoTriState.msoFalse,
Microsoft.Office.Core.MsoScaleFrom.msoScaleFromTopLeft)
oRng.Comment.Shape.ScaleHeight(1.5,
Microsoft.Office.Core.MsoTriState.msoFalse,
Microsoft.Office.Core.MsoScaleFrom.msoScaleFromTopLeft)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
How DO I Increase The Excel Cell Comment Data Capacity? 1
POWERPOINT 2008 - HOW TO 'PRINT COMMENT'? 1
Excel comments moving and changing sizes 2
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL 5
How did I lose ability to add/edit comments in Excel 4
Subject: Suggestion for Excel 2007 - Comment Coloring 0
How do I set the default comment format and view in Excel 1

Top