Showing Comments
 

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

Showing Comments
 

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

On Tue, 3 Jun 2008 08:30:01 -0700, Moz wrote:

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

Showing Comments
 

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

"Gord Dibben" wrote:

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

On Tue, 3 Jun 2008 08:30:01 -0700, Moz wrote:

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

Showing Comments
 

With your workbook open.

Alt + F11 to open the Visual Basic Editor.

CTRL + r to open Project Explorer.

Select your workbook/project and right-clickinsertmodule.

Copy/paste the code into that module.

Alt + q to return to the Excel window.

ToolsMacroMacros to Run the macro.

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

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


Gord


On Tue, 3 Jun 2008 11:36:00 -0700, Moz wrote:

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

"Gord Dibben" wrote:

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

On Tue, 3 Jun 2008 08:30:01 -0700, Moz wrote:

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