Is it possible to get an outline bo

[segmentationfault]

Is it possible to get an outline border in an Excel header? This is necessary for a proprietary information label and management is picky about having a border.

If that isn't possible, is there a way I can print an Excel file with a MSWord header?

I'm currently playing around with the VPageBreak and HPageBreak collections and inserting the proprietary information label directly into the worksheet, but this is a very complicated way to do it. I really hope there is a better way.

Thanks.

 

[xlbo]

Could you use the "Rows to repeat at top feature" instead of the header.... Put the PI text in these rows and stick a border round the cells.
Rgds
~Geoff~

 

[segmentationfault]

That is a great idea and I'm probably going to include it in the solution, but there are still some issues:

o As far as I can tell, I will need to repeat the label following every vertical page break (it must be on every sheet of paper)

o There will be a different label on the first page than the other pages (the first label is long and intimidating while the other pages refer to the label on the first page.)

There are some instances in which there will only be one version of the label used (for internal documents) and this will work nicely.