I could make use of Comments attached to individual for
storing contextual information in a highly automated multi-
worksheet "database" that I have developed and use a lot.
This would keep the spreadsheets simple and, although the
information stored in them would not be immediately
displayed on the screen, it could be easily accessed and
read by users. By entering the comments using a shape
commands, the comment box can also be made fairly
attractive to view. For eaxmple,

With....
.Comment.Shape.AutoShapeType =
msoShapeFlowchartAlternateProcess
.Comment.Shape.Height = ptsHeight
.Comment.Shape.Width = ptsWidth
...
End With

However, I am concerned that adding a lot of comments to a
workbook, which is already 3.5 megabytes and contains over
40 weorksheets, could eventually slow it down and lead to
problems.

Using comments in this way would essentially amount to
storing a consdierable amount of the information in
antoehr dimension of the workbook besides table cells --
i.e., comment boxes attached to those table cells
containing contextual information.

The conservative in me says this might lead to trouble if
a lot of the comment boxes are added. I have visions of
100s or 1,00s of pointers colliding with each other and
bringing the whole workbook down.

Is there any cause for concern? shoudl I stop this
foolishness?

John Wirt