Scribd
Upload
86 views1 page

Unbold Comments Code

This VBA code unbolds all comments on the active worksheet. It uses a For Each loop to iterate through each comment using the Comments property of the active sheet. Within the loop, it sets the Bold property of the font of each comment's shape text frame to False, unbolding the text.

Uploaded by

Venkat Sai Kumar Kothala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
86 views1 page

Unbold Comments Code

This VBA code unbolds all comments on the active worksheet. It uses a For Each loop to iterate through each comment using the Comments property of the active sheet. Within the loop, it sets the Bold property of the font of each comment's shape text frame to False, unbolding the text.

Uploaded by

Venkat Sai Kumar Kothala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Sub UnboldAllComments()

'Unbold all comments on the active worksheet


Dim Cmt As Comment
For Each Cmt In ActiveSheet.Comments
Cmt.Shape.TextFrame.Characters.Font.Bold = False
Next Cmt
End Sub

You might also like