Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Global Change COmments Properties (XP 5.1)

    I have a spreadsheet with numerous comments that I did not set the properties correctly (move but dont size) as I created them. Is there a way of globally changing the comments to 'move but dont size with cells'.

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Global Change COmments Properties (XP 5.1)

    When you say "Comment" do you mean something like an AutoShape (which can be adjusted to move and size with cells or not).

    If you mean AutoShape, then try something like:

    dim oShape as Object
    For each oShape in Sheet1
    oShape.Placement = xlFreeFloating
    Next

    Paul

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Global Change COmments Properties (XP 5.1)

    Comment is the 'note' that you can stick in a cell (Insert-Comment).

  4. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Global Change COmments Properties (XP 5.1)

    Sorry,
    I was thrown off by the "Move but don't size with cells" and was unaware of the ability to do this with COMMENTS.

    Now that I have figured out that this is accessible manually with INSERT -- EDIT COMMENT -- FORMAT --COMMENT
    I tried the position settings. I see that the comment SIZE will change with the cell (if checked) but I am
    unable to see any difference in the MOVE part whether the button is checked or not.

    Can you explain this? Doesn't a comment ALWAYS move with a cell -- unlike a drawing object like an AutoShape?
    This is what threw me off at first.

    Paul

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Global Change COmments Properties (XP 5.1)

    Sorry, in the time I have available I cannot seem to tie down the property.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Global Change COmments Properties (XP 5.1)

    This should do it for every comment in the workbook.

    Steve

    <pre>Sub AllCommentsMoveNoSize()
    Dim wks As Worksheet
    Dim cmt As Comment

    For Each wks In Worksheets
    For Each cmt In wks.Comments
    cmt.Shape.Placement = xlMove
    Next
    Next
    End Sub</pre>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •