View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
timrek4
 
Posts: n/a
Default print many comments fields below header lines

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.