Showing Comments

[Moz]

I had my comments set so that when you put the mouse over the cell it showed
the comments. For some reason now I have to select the comment, show the
comment, go clear up to the top portion for spreadsheet and find a pointer
line, click on it and resize the comment window to view the comment. What
did I do that cause this and how can I fix it globally. Once I fix a cell it
then works like before. Just place the mouse over the comment and it shows.

Help

 

[Gord Dibben]

From Debra Dalgleish...........

If comments have moved out of position, you can reset them using the following
code:


Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub



Gord Dibben MS Excel MVP

 

[Moz]

Not sure exactly how or where I type this code in at??

 

[Gord Dibben]

With your workbook open.

Alt + F11 to open the Visual Basic Editor.

CTRL + r to open Project Explorer.

Select your workbook/project and right-click>insert>module.

Copy/paste the code into that module.

Alt + q to return to the Excel window.

Tools>Macro>Macros to Run the macro.

For more on storing and running macros see Ron de Bruin's site.

http://www.rondebruin.nl/code.htm


Gord