ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Oggetto: Automatic Borders On Breakpage (https://www.excelbanter.com/excel-programming/384634-oggetto-automatic-borders-breakpage.html)

Michel

Oggetto: Automatic Borders On Breakpage
 
Hello, I am quite new in this forum. My question is as follow = I am
developing an Excel tool for sales purposes. This tool contains a search
engine and refers to an internal table of the Excel file. After chosing the
item, it copies automatically into a proper table to present the quotation to
the client. I would like to be sure that a border is automatically created on
each side of the page break (horizontal and vertical) to make the document
more professional. Please, could you let me know how I can develop a macro
which will automatically create borders on each 4 page breaks
(top/bottom/right/left) ? This has to be done for each page of the table
Excel and with/without the full page (ie, the horizontal bottom page breaks
should be still the same - same page size). if you have got any idea,
suggestions or examples, please let me know. Thanks a lot. Regards. Michel



All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com