How to repeat titletrow from A1 to M1, in printer setup?
In vb6 naturaly.
PrintTitleRows
-
- Administrator
- Posts: 78416
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: PrintTitleRows
Assuming that the variable WS is set to the worksheet that you want to print:
Code: Select all
WS.PageSetup.PrintTitleRows = "$1:$1"
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4353
- Joined: 26 Apr 2010, 17:36
Re: PrintTitleRows
OPS...HansV wrote: ↑13 Nov 2021, 15:02Assuming that the variable WS is set to the worksheet that you want to print:
Code: Select all
WS.PageSetup.PrintTitleRows = "$1:$1"
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
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78416
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: PrintTitleRows
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
See Ripetere righe e colonne come titoli o etichette su ogni pagina stampata
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4353
- Joined: 26 Apr 2010, 17:36
Re: PrintTitleRows
same effect always in grey, and disabled...HansV wrote: ↑13 Nov 2021, 16:03You 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
have you tested with my WB?
-
- Administrator
- Posts: 78416
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: PrintTitleRows
Yes:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4353
- Joined: 26 Apr 2010, 17:36
-
- Administrator
- Posts: 78416
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- PlatinumLounger
- Posts: 4353
- Joined: 26 Apr 2010, 17:36
-
- Administrator
- Posts: 78416
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands