Re: Showing Comments

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


On Tue, 3 Jun 2008 11:36:00 -0700, Moz <Moz@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 Active***.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 <Moz@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 spread*** 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



.

Quantcast