Excel macro to modify table comments: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

20 November 2024

  • curprev 16:3316:33, 20 November 2024‎ Mwroot talk contribs‎ 656 bytes +656‎ Created page with "同事用 WPS 做的表格批注，用 MS Office Excel 打开，批注框糊成一小块，看不全，用以下宏可解决。 <syntaxhighlight lang="VBScript" line> Sub ResizeAllComments() Dim ws As Worksheet Dim cmt As Comment For Each ws In ThisWorkbook.Worksheets For Each cmt In ws.Comments With cmt.Shape .Width = 200 ' 设置批注框宽度，可根据需要调整 .Height = 50 ' 设置批注框..."
Retrieved from "https://qingliezhiquan.com/blog/Excel_macro_to_modify_table_comments"