Automatic Borders On Breakpage

[Michel]

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

 

[Paul Herber]

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

But this is a Visio rather than an Excel newsgroup (not a forum).

How did you get here? Whichever interface it is is either broken or
badly designed to cause confusion between Excel and Visio.