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.
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.
[vba]
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.PrintComments = xlPrintInPlace
End With
End Sub
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks Bob.
Posting Permissions
Reply With Quote
