Basic view/print question

[ksucats4me]

Is there an option in excel that will print all of my comments put into cells? I see this as a very powerful option that can strengthen my documentation process.

Thanks?

 

[lenze]

File>PageSetUp>Sheet Tab
For Comments select
1)None(default)
2)At end of Page
3)As Displayed

lenze

 

[ksucats4me]

Thanks... found it almost immediately! Not a perfect format, but better than what I had before!

 

[lenze]

You could use a macro to copy comments to a new sheet and print that sheet.

Sub CommentMe()
Dim cm As Comment
Dim mytext As String
Dim i As Long
i = 1
For Each cm In ThisWorkbook.ActiveSheet.Comments
mytext = cm.Text
ThisWorkbook.Sheets("Sheet2").Cells(i, "A") = mytext
i = i + 2
Next cm
End Sub

lenze