PDA

View Full Version : Retain Comments in Printout of excel



Jade
05-06-2010, 07:52 AM
Hi,

I am working on a piece of code that will print a excel workbook but the fix is that I am not able to figure out how to retain comments in the printout ..???
This is achieveable from excel itself by first setting the "Show all comments" option under the "Review" ribbon of excel and then changing the comment option in sheet tab of page setup dialog box of page layout ribbon to as displayed on sheet...

I am going nuts by figuring out how to do it programmatically in vb...!!!:banghead:

Can please someone throw some light on same..???

Thanks,
Jade

mdmackillop
05-06-2010, 09:28 AM
Try

Application.DisplayCommentIndicator = xlCommentAndIndicator

Jade
05-06-2010, 10:50 PM
mdmackillop this doesn't do the job...

Can we do something programatically so that the comments are visible in the printout also...??

Thanks for replying,
Jade

JONvdHeyden
05-07-2010, 12:48 AM
Hello Jade

There are various VB solutions for printing comments here (http://www.contextures.com/xlcomments03.html).

Jade
05-07-2010, 01:27 AM
thanks a lot Jon von der Heyden , I will definitely look into all those and see if they serve the purpose...

Thanks for replying
Jade

lynnnow
05-07-2010, 02:11 AM
Very interesting site. Thanks Jon.:beerchug: