PrintTitleRows

[sal21]

How to repeat titletrow from A1 to M1, in printer setup?
In vb6 naturaly.

[HansV]

Assuming that the variable WS is set to the worksheet that you want to print:

Code: Select all

    WS.PageSetup.PrintTitleRows = "$1:$1"

[sal21]

Assuming that the variable WS is set to the worksheet that you want to print:

Code: Select all

    WS.PageSetup.PrintTitleRows = "$1:$1"

OPS...

error 438.

but before to set this via code i make this in Excel...

i cannot set via setting print!!!

all action are disabled!

see image

[HansV]

You must select Print Titles (Stampa titoli) from the Page Layout (Layout di pagine) tab of the ribbon. Not from File > Print.
See Ripetere righe e colonne come titoli o etichette su ogni pagina stampata

[sal21]

You must select Print Titles (Stampa titoli) from the Page Layout (Layout di pagine) tab of the ribbon. Not from File > Print.
See Ripetere righe e colonne come titoli o etichette su ogni pagina stampata

same effect always in grey, and disabled...

have you tested with my WB?

[HansV]

Yes:

S0876.png

[sal21]

Yes:


S0876.png

ok tks and sorry.
possible causes?

[HansV]

Have you tried closing and reopening the workbook?

[sal21]

Have you tried closing and reopening the workbook?

PERPAHS corrupt...

i have used .xlsx file, instead .xls, and now work.

tks

[HansV]

Good to hear that