cmt

I have the following which seems to reset comment/note boxes only when the red indicator is hovered over: Sub ResetComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Top = cmt.Parent.Top + 5 cmt.Shape.Left = _ cmt.Parent.Offset(0, 1).Left + 5 Next End Sub However...

Hi, I have an Excel Sheet1 with data in it and several comments scattered here and there. I think each comment has an identification number automatically assigned to it when it is created? Maybe ID? or Item? Not sure! I want a VBA macro to list all the comments to another sheet (say Sheet2)...

I have the following to change the comment box size for one cell as follows: Sub Comments_Formatonecell() ActiveCell.Comment.Shape.Width = 540 ActiveCell.Comment.Shape.Height = 150 End Sub Then this to do the same for all cells: Sub Comments_Format() Dim cmt As Comment For Each...

I have code that standardizes all comment boxes but is it possible to isolate this for one cell? The reason I'd like this is because boxes are getting squished flat or distorted when moved around even if "locked" This is what I have: Sub Comments_Format() Dim cmt As Comment For Each...

I have the following to standard comment box sizes for a sheet: Sub Comments_Format() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Width = 100 Next cmt End Sub is it possible to apply this to just one column? Thanks! Steve

I have the following to set "shadow" to false but don't know how to do the same for the "lock aspect ratio" setting to true. Sub Comments_Format() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Shadow.Visible = msoFalse Next cmt End Sub Where would I find this method...

I have the following to set "shadow" to false but don't know how to do the same for the "relative to size" setting to true. Sub Comments_Format() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Shadow.Visible = msoFalse Next cmt End...