cmt

  1. S

    anchoring comments/notes active vs non-active cells

    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...
  2. L

    How to list certain details about all comments in a worksheet?

    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)...
  3. S

    change text box size for a range of cells...

    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...
  4. S

    unsquishing comment boxes for individual cells...

    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...
  5. S

    standardize comment box size in a single column...

    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
  6. S

    method to format comment "lock aspect ratio" setting all to "true" under "size" tab...

    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...
  7. S

    setting "relative to original picture size" to true in comments...

    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...

Watch MrExcel Video

This Week's Hot Topics

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
Top