Hi,

I have a report that uses groups that is sent out to others. When sent, the groups are collapsed for ease of veiwing. Is there a way (macro or any other) to automatically expand the groups on the sheet and print them when a user clicks on a designated cell (titled "Print", perhaps)?

thanks,

ebaymark2002