Hi,
Excel forum newb here. I have a problem resulting from my company's upgrade from Office 2003 to Office 2007. We have an Excel application that that allows a user to enter data. Clicking a "generate" button causes the program to "generate" new worksheets, organizing the data in a client-specific format (to be incorporated into our roadway construction plans). The worksheets can be multiple pages depending on the amount of data, traveling up to down on one worksheet. The bottom border of the first sheet is shared as the top border of the second sheet, (and the second's bottom is shared with the third's top, etc. etc.). This used to work in excel 2003. The upgrade to 2007, results in a loss of bottom borders (top borders continue to print). This can be manually fixed, but it is a tedious, labor intesive job - not to mention stupid.
Any suggestions?

The "generate" code is done in vba, by what looks like an amateur. I can access and change the code, but trying to interprete it can be a nightmare.

All in all, I would not have choosen to develop the automated spreadsheet this way, but alas, client requirements and budgets leave me no choice.

Thanks,