PDA

View Full Version : Solved: macro to print cell comments



austenr
08-05-2007, 12:30 PM
Is there a macro way to print cell comments progmatically? I have 4 cells with comments I want to give the user the ability to print them if they wish.

Bob Phillips
08-05-2007, 12:48 PM
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.PrintComments = xlPrintInPlace
End With
End Sub

austenr
08-05-2007, 12:57 PM
Thanks Bob.