View Single Post
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default How can I create a footer containing more than 255 characters

I don't think VBA will allow you to break this rule either.

In xl2002+, you could add a picture to the footer (and maybe you could create a
picture of your disclaimer).

Maybe print a bunch of sheets with just the disclaimer (created in MSWord) and
then printing the excel data on a second pass through the printer.

Maybe...Put it in some cells and then use rows to repeat at Top (move it to the
header).

Fred1025 wrote:

I have a legal disclaimer that needs to print on the bottom of each page in
an Excel spreadsheet. I tried to get it shortened, but the minimum length in
555 characters. Is there any way to produce footers longer than 255
characters?

I could build a routine to print the footer in VBA, but I would like to
avoid that if possible.

Thanks.


--

Dave Peterson