software

Have worksheet with 120 fields that each have a comment in top row of 4
header rows. Comments contain definitions and/or lists of values for each
field.

Worksheet is protected and comments are not arranged for printing since many
overlap each other and the headers.

Want to print our headers with the comments below without having to
rearrange each comment field separately.

Also want to keep this arrangement in event that various worksheet columns
are hidden or revealed by macros in the workbook.

Hi ....,
Sorry, but I do not understand your question.

You have no control over *where* comment boxes are displayed, except for the
ability to move them around a bit when presented.

You can choose whether comment boxes and/or indicators show automatically
Tools, options, view, comments: ---

You can print your comments with cell references at the end of your printout
file, page setup, sheet, print comments

or with more control you can use a macro
www.contextures.com/xlcomments01.html#Printing

some more macros for printing or displaying comments in
www.mvps.org/dmcritchie/excel/ccomment.htm

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;timrek4quot; gt; wrote in message ...
gt; Have worksheet with 120 fields that each have a comment in top row of 4
gt; header rows. Comments contain definitions and/or lists of values for each
gt; field.
gt;
gt; Worksheet is protected and comments are not arranged for printing since many
gt; overlap each other and the headers.
gt;
gt; Want to print our headers with the comments below without having to
gt; rearrange each comment field separately.
gt;
gt; Also want to keep this arrangement in event that various worksheet columns
gt; are hidden or revealed by macros in the workbook.