MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Print Comments -and- No/ Comments Macro's

Posted by KShields on February 17, 2001 3:17 PM

I have 2 custom menu's set-up one to print a sheet with comments, one to print a page without comments. I can't get the code to run as it seems that it defaults to the settings in my Page Setup. In other words, to whatever it is setup to do in the Page Setup.

Maybe there is another way to approach this.

Posted by Dax on February 18, 2001 8:26 AM

You need to include these lines in your macro. For the macro that doesn't print comments add this line : -

ActiveSheet.PageSetup.PrintComments = -4142

In the other one change the -4142 to 16 (Excel constant xlPrintInPlace or 1 (xlPrintSheetEnd).

Hope this is clear,

Posted by Dax on February 18, 2001 12:59 PM

Thank-you Dax! Yes it was clear to me and YES it works! Thanks so much!

By any chance do you know what shape does to a comment? What would be the proper code? I have a 17 page workbook with the opportunity of the end user to post up to 5 lengthy comments per page. The comment box stays small when you run your cursor over the cell with the comment.

Again, thank-you.