Insert Comment

DrBourse

New Member
Joined
Jul 10, 2014
Messages
12
Hi Folks, Having a problem using a large S/S with hundreds of Comment Boxes(with the small red triangle top left of a cell).
These Comment Boxes seem to have a mind of their own - occasionally they magically resize themselves.
I have to set these comment boxes at 25cm x 21cm to suit our needs.

Would anyone have a way of me setting 25cm x 21cm as a default box size.
Thanks
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Hi Folks, Having a problem using a large S/S with hundreds of Comment Boxes(with the small red triangle top left of a cell).
These Comment Boxes seem to have a mind of their own - occasionally they magically resize themselves.
I have to set these comment boxes at 25cm x 21cm to suit our needs.

Would anyone have a way of me setting 25cm x 21cm as a default box size.
Thanks
That's a prodigious comment :wink:. You didn't say which is width/height so you may have to switch the values in red below.
Rich (BB code):
Sub SizeComments()
Dim oCom As Comment
For Each oCom In ActiveSheet.Comments
          With oCom
                    .Shape.Width = Application.CentimetersToPoints(25)
                    .Shape.Height = Application.CentimetersToPoints(21)
          End With
Next oCom
End Sub
 
Upvote 0
Hi JoeMo, Thanks 4 your reply - Sorry about that oversight of mine - I need Height @ 25cm, Width @ 21cm - Cheers
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top