stablize the Excel comment boxes (size and location)

[Guest]

I use Excel spreadsheets to gather prerequiste information from my clients
before we install software at their site. The comments are very important to
the clients because they explain what is needed in each cell. The trouble
is, these comment boxes seem to resize themselves at will, and you have to
enlarge them before you can read the contents. Sometimes they become just a
vertical line. I'm always apologizing to my clients for this 'feature' in
Excel. Is there a way to lock the size and location of a comment box in a
worksheet? If not, consider this an enhancement request.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d-f2e72df7e290&dg=microsoft.public.excel.misc

 

[Guest]

Maria

If you do not mind a macro you can modify this.
Sub t1()
'this works
Set rng = Range("C4:c9")
For Each c In rng
On Error Resume Next
c.Comment.Shape.Select
Selection.ShapeRange.Height = 24
Selection.ShapeRange.Width = 49
Next
Cells(1, 1).Select
End Sub

Press ALT + F11, choose insert Module and paste in the code. Return to excel
and choose Tools, Macro (ALT + F8) and run the macro.
You will need to change the range to cover where your comments are and also
play around with the height and width. If this continues then you can assign
it to a Form button View, Toolbars, Forms - Click the 4th one and draw it one
the worksheet. You will be prompted to assign the code you have placed in the
VB Editor.

Regards
Peter