Custom print comments in Excel 2007

[Thomas Guignard]

Hi there

There are two ways to print comments in Excel, either the WYSIWYG way
(little stacked boxes over the actual worksheet) or as separate pages.
Problem with the separate pages way: the comments get printed as

Cell: B9
Comment: User name:
Comment...

Now, the cell number is not necessarly the easiest way to locate a
specific cell. My question: would it be possible to replace the cell
number with, for example, the content of the cell or the content of the
neighboring cell?

I'm not an expert in VBA programming, but if someone could point out
where I should start to customize the comment printing options, maybe I
will be able to sort out the rest.

Thanks for your help.

 

[Thomas Guignard]

Never mind, I found a way to do it by adapting the code found here

http://www.mvps.org/dmcritchie/excel/ccomment.htm#printcommentsbycolumn

Now I only need to find out how to execute this code every time I want
to print my workbook.