How can I make this happen?

[foxspirit]

I want a macro or something that will allow me to "show" every comment
on a work sheet (there are almost 100) then go to Format Comment and
Properties and change it to "move and size with cells" then rehide the
comment. Any ideas?

 

[foxspirit]

On a worksheet is there a function that unhides all comments in every
cell?

 

[scottymelloty]

highlight page, click on view, then comments , think this shows them al
, there probbaly going to be ove rlapping etc, think there's othe
options to look thro each comment one at time etc as wel

 

[foxspirit]

Thanks Scott. Guess I will just have to manually change the properties
of each one.

 

[foxspirit]

Thanks Scott. Guess I will just have to manually change the properties
of each one.

 

[Dave Peterson]

You don't need to show it to change that setting:

Option Explicit
Sub testme01()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Placement = xlMoveAndSize
Next cmt
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[foxspirit]

Works perfectly. You just saved me an hour. Thanks