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
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