Comment Bug? Excel 2002

  • Thread starter Thread starter usawargamer
  • Start date Start date
U

usawargamer

Using Excel 2002, I have a spreadsheet with many cells and comments.
(lets say 400 rows and 10 columns, with commenst all over)

I made 5 seperate groups (lets say rows 1-50, 53-103, 106-156, 160 -
210, etc.)

When I expand a group, do some editing , add a comment or edit a
comment, collapse the group, and come back to the cell later, sometimes
the comment boxes for the cells are moved very far away, and their size
is distorted (flattened to a thin line or squished to a single
character wide).

Is this a bug with the group function, when collapsing un collapsing
data?

Is there some option I can set?

Anyone experience this? Any ideas?

Its very annoying to have scores of comments moved around.
 
Using Excel 2002, I have a spreadsheet with many cells and comments.
(lets say 400 rows and 10 columns, with commenst all over)

I made 5 seperate groups (lets say rows 1-50, 53-103, 106-156, 160 -
210, etc.)

When I expand a group, do some editing , add a comment or edit a
comment, collapse the group, and come back to the cell later, sometimes
the comment boxes for the cells are moved very far away, and their size
is distorted (flattened to a thin line or squished to a single
character wide).

Is this a bug with the group function, when collapsing un collapsing
data?

Is there some option I can set?

Anyone experience this? Any ideas?

Its very annoying to have scores of comments moved around.
Click to expand...

You are not alone as I'm having much the same problems with Excel XP.

My comments are all in one column and about 450 rows deep.

When I add more rows, then cut and paste the new rows all looks OK but
when I save... close down the 'puter and restart another day the
comments have disappeared or have moved to other columns.

I now add just one row at a time and that seems to work with the
comments staying in the correct row and column.

My comment boxes are usually about 85 chrs wide and two rows high.

I found the following macro on and which sets the comment box width
size.

******************************************
Sub Commentboxsize()
'
' Macro1 Macro
' Macro recorded 7/24/2003 by xxxx
'

'
Dim d As Object
For Each d In ActiveSheet.Comments
d.Shape.Width = 400
'c.Shape.Height = 22
'd.Shape.TextFrame.Characters.Font.Bold = True
'd.Shape.TextFrame.AutoSize = True
Next d

End Sub
********************************************

Wish one of the gurus would jump in with a solution.

Ron
 
Back
Top