Two two solutions shown do not address the problem. If I am not running a
macro the comments are only displayed when I hover over them. This is what I
want to do. When a macro is running they are not displayed

"FSt1" wrote:

hi
a suggestion.
you could add code to your macro to unhide your comments while the macro
runs then add code at the end of the macro to hide the comments again
from Debra Dalbleish's site contextures
Sub ShowSheetComments()
'shows all comments on the active sheet
Dim c As Comment

For Each c In ActiveSheet.Comments
c.Visible = True
Next

End Sub
http://www.contextures.com/xlcomments03.html#Show

regards
FSt1

"Oldjay" wrote:

Excel2003 XPsp2
I have a le worksheet with more than 75 comments.
If you are running a macro they do not display when you hover over them.
Is there a way to make the comments visable?